(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.
(Gerald) Did you know that Oracle Linux is also available for ARM processors? That means that you can install Oracle Linux on an SD card for a Raspberry Pi as well. Below I will show you how to do that with a Mac.
Serverless Node Function on Oracle Functions runs periodically to produce CSV report on Oracle ObjectStorage from data in ElasticSearch
(Lucas Jellema) This article highlights a use case implementation I recently implemented (for a demo session) leveraging Oracle Functions as well as OKE (Oracle Kubernetes Engine), Object Storage and Elastic Search.