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

Oracle NoSQL Kvstore (1.2.123) deployment demo

With the next turn fold of web2.0, database paradigms have molded their behaviors too to map the requirements and expectations. NoSQL is a database of modern times where the database platform is need based rather than rule based. Rather being generic, traditional or conventional, its more suited for limited – perhaps specific requirements. Leading software giants like… Read More Oracle NoSQL Kvstore (1.2.123) deployment demo

Oracle Engineered Systems: Hardware and Software Engineered to Work Together

Oracle Engineered Systems are highly efficient integrated systems which combine hardware and software to provide a complete enterprise solution to the customers or partners. The focus of the Oracle Engineered Systems is to give extreme performance, high scalability and maximum availability by reducing infrastructure complexity and setup cost. The pre assembled innovative systems have greatly… Read More Oracle Engineered Systems: Hardware and Software Engineered to Work Together