(stewashton) I frequently use what I call “SQL templates”, where I replace multiple placeholders by calculated values. Here are two methods that don’t require a stored procedure.

(Franck Pachot) Virtual Private Databases (VPD) is an Enterprise Edition feature related to security. It restricts the scope of Data Manipulation Language to a subset of the table rows by transparently adding a where clause before executing them.

(Andrejus Baranovskis) These days I’m actively working with VBCS/JET Cloud product from Oracle. The more I work with VBCS the more I like it. VBCS follows similar declarative development concepts as Oracle ADF, this makes it easy to get up to speed with VBCS development.

(David Fitzjarrell) There are occasions when two or more data sets need to be combined to produce the desired results, and a join is not possible (no common columns, no common data values to join on).

(Mohamed Azar) RMAN Backup script :

(Roel Hartman) If you are using multiple containers to set up your Oracle Development (or Test or Production) environment – as I described here – you probably ran into the issue that your ORDS container was started before the Database was started up.

(amitzil) This is an old story. It started in 2015 when I found a problem with TOP-N query performance.

(Mohamed Azar) While Cloning

(Franck Pachot) The Oracle Database software is large, several gigabytes in Oracle Home for the part that is deployed on the operating system, and additional megabytes in SYSTEM tablespace for the part that is deployed as stored procedures (mainly the dbms_% packages).

(Scott Wesley) It’s only taken a year, but I’ve finally checked out the ability to switch authentication schemes at runtime with 18.x.