Oracle Database 12c PRAGMA UDF and WITH clause enhancements

Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause. Functions declared in the PL/SQL declaration section can be invoked instantly in the… Read More Oracle Database 12c PRAGMA UDF and WITH clause enhancements

Recent Articles at Exforsys (XML Storage and 11g Analytic Enhancements)

Hope you all are liking the book and my wish that it reaches my readers. I am satisfied with the good response of the readers. The fact that the book features into Oracle magazine (July-August 2012) issue and Oracle ACE newsletter has already overwhelmed me with joy and excitement. Once again, thanks to Exforsys for… Read More Recent Articles at Exforsys (XML Storage and 11g Analytic Enhancements)

Discovering the Author within me: My upcoming book

Happily I would announce the listing of my upcoming book at PacktPub publishers website. The book is expected to be released by May, 2012. The book is for the Oracle Associate professionals who are aspiring for Professional level exam (1Z0-146 certification). “The¬†Oracle Advanced PL/SQL Developer Professional Guide¬†helps you master advanced PL/SQL concepts. Besides the clear… Read More Discovering the Author within me: My upcoming book