(Andrejus Baranovskis) ADF 12.2.1.x brings improved API support for Contextual Event implementation – this should simplify Contextual Event usage. Now Contextual Events can be produced without referencing ActionEvent or SelectionEvent, also there is no need to define Data Control to implement Contex
(amitzil) When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes.
(Hemant K Chitale) Continuing this series of posts where I have a SingleInstance/FileSystem Standby database for a RAC/ASM database …
(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.
Oracle Database Backup Service Fails with: ORA-19511: – KBHS-00715: HTTP error occurred ‘oracle-error’
(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.