(mdinh) Often, I am quite baffle with Oracle’s implementations and documentations.

(Connor McDonald) One of the nice things about the job scheduler in the Oracle database is the easily interpreted interval settings you can apply for job frequency.

(Martien van den Akker) Today I found something curious in a composite upgraded from 11g to 12c, regarding DVMs. I sometimes use DVMs in BPEL to prevent the use of complex xpath expressions with many conditions.

(Dirk Nachbar) Since last night the lastest Oracle Database Release 19c (19.3) is for On-Prem available.

(Neil Chandler) I’ve noticed at a few clients with data warehouses recently that the Developers and, upon occasion, Business Users have a real fondness for hinting the SQL they are producing with one particular hint. PARALLEL.

(Jagruti Jasleniya) In a previous post, we have seen how we import backup from non-cdb to pdb.

(Richard Foote) I’ve recently received a number of correspondences regarding one of my most popular blog posts, dating back to February 2008: Index Rebuild vs. Coalesce vs. Shrink Space (Pigs – 3 Different Ones).

(mgogala) I was very excited when I learned about the new feature in Oracle 18c, namely the private temporary tables.

(Jeff Smith) Version 19.1 of SQL Developer, SQLcl, Data Modeler, and ORDS are now all available, and you can expect many posts over the next few weeks to cover all the new goodies.

(Jagruti Jasleniya) In this post, we will see how we can take an export from one pdb and import into another pdb.