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

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