Here’s a collection of interesting articles I’ve read this week.
Articles I’ve Read
Jonathan Lewis writes an article about some improvements to the TRUNCATE statement in Oracle 12c, and how it relates to “on delete cascade”. THere’s a small example and a good explanation on how it works.
Step by Step Mastering Oracle Database Cloud Service – DBaaS – in one pdf now!
Kamran Agayev has combined a lot of his recent Oracle Cloud related posts into a single PDF for download/
Generate XML data using SQL in Oracle Database
Nimish Garg wrote this post to explain how to generate XML data using SQL in Oracle. There are some functions related to XML that can be used for this.
Defining the tablespace for several objects at the same time
Heli describes, with screenshots, how to define the tablespace for a large number of indexes in a single operation. This can be a real time saver.
Image courtesy of Graphics Mouse / FreeDigitalPhotos.net