Here’s a collection of interesting articles I’ve read this week.

Articles I’ve Read

Truncate 12c

https://jonathanlewis.wordpress.com/2017/02/16/truncate-12c/

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!

http://kamranagayev.com/2017/02/16/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

http://nimishgarg.blogspot.com.au/2017/02/generate-xml-data-using-sql-in-oracle.html

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

https://helifromfinland.blog/2017/02/15/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.

Want an Oracle SQL function cheat sheet for easy reference? Click here to get a PDF file that contains all of Oracle functions for you to reference or print out.

Image courtesy of Graphics Mouse / FreeDigitalPhotos.net

Improve Your Oracle SQL With My 10-Day Email Course

x