#DB12c feature – Secure External Procedures with DBMS_CREDENTIAL

Oracle Database 12c enables enhanced security for extproc by authenticating it against a user-supplied credential. This new feature allows the creation of a user credential and links it with a PL/SQL library object. Whenever an application calls an external procedure, the extproc process authenticates the connection before loading the shared library. The DBMS_CREDENTIAL package is… Read More #DB12c feature – Secure External Procedures with DBMS_CREDENTIAL

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

Interview with Saurabh K. Gupta, Author of ‘Oracle Advanced PL/SQL Developer Professional Guide’

    Saurabh is the author of our recently published Oracle Advanced PL/SQL Developer Professional Guide Which helps master the advanced features of PL/SQL to design and optimize code using real-time demonstrations.               Find the complete interview at the below link http://authors.packtpub.com/content/interview-saurabh-k-gupta-author-oracle-advanced-plsql-developer-professional-guide