(Morten Braten) Do you need to send SMS (Short Message Service) text messages from your Oracle database using PL/SQL? This is actually quite easy to do, the only hard part is deciding on which SMS gateway to use.

(Richard Foote) I previously discussed how Index Advanced Compression can automatically determine not only the correct number of columns to compress, but also the correct number of columns to compress within specific leaf blocks of the index.

(Michael McLaughlin) Have you ever wondered how to leverage substitution variables in anonymous block programs? There are several tricks that you can use beyond passing numeric and string values to local variable.

(Roel Hartman) Developers with an Oracle Forms background might still remember this nice feature: If you click on a row in an Oracle Form “report” then it can be highlighted – either the full row or just a small first item of the row.

(Fahd Mirza) I manually created a container database (CDB) 12.1.0.2.0 in my Linux 6.4 based virutal machine. After creating it, I tried to create a pluggable database but got following error:

(Michael McLaughlin) Have you ever wondered how to leverage substitution variables in anonymous block programs? There are several tricks that you can use beyond passing numeric and string values to local variable.

(Roel Hartman) Developers with an Oracle Forms background might still remember this nice feature: If you click on a row in an Oracle Form “report” then it can be highlighted – either the full row or just a small first item of the row.

(Fahd Mirza) I manually created a container database (CDB) 12.1.0.2.0 in my Linux 6.4 based virutal machine. After creating it, I tried to create a pluggable database but got following error:

(Jeff Smith) One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010.

(connormcdonald) Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as: