(Ben Brumm) Have you gotten an ORA-00942 error? I’ll explain the cause and the solution of the error in this article.

(Scott Wesley) I’ve been following the LISTAGG problem for a while because I find the function useful.

(David Fitzjarrell) Transactions are the lifeblood of a relational database and Oracle is no exception. Key to this concept is the ability to replay those transactions should the need arise to recover ‘lost’ data due to a database crash, or worse, corruption requiring a restore and recovery.

(Brendan Tierney) This blog post looks at how to format the output or the returned returns from an Oracle R Enterprise (ORE), user defined R function, that is run using a SELECT statement in SQL.

(Jeff Smith) Let’s say you have some files, stored as BLOBs, in your database, and you want to make them available via REST.

(Zahid Anwar) I discovered an Oracle Cloud Database Backup failing with:

(Ben Brumm) Did you get an “ORA-00904: invalid identifier” error? Find out what caused the ORA-00904 error and how to resolve it in this article.

(Richard Foote) If you like the look of the new Index Advanced Compression setting of “High” available with Oracle Database 12c Release 2 as I’ve discussed previously in Part I and Part II, well there’s a way to make this the default index compression method in your 12.2 database.

(Richard Olrichs) Memory scopes itself can be confusing enough, therefor I always advise my fellow developers to use the ADF scopes as much as possible and avoid the JSF scopes if they can.

(Harry Dragstra) Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to comply to “ora12c_strong_verify_function”, and this isn’t as easy to generate as you might expect.