PL/SQL Native Compilation in Oracle 11g

During the introduction of Objects and Types in Oracle 8 release, PL/SQL was referred as procedural and object oriented language. While Oracle 9i and 10g were more concentrated on the sharpening of the object oriented model of Oracle, Oracle 11g aims at evolving PL/SQL from interpreted language to natively compiled language. In the tutorial, we shall see the changes made to achieve native compilation and its post application effects. Interpreted to Native Compilation: A Tour Native compilation of program units was first introduced in Oracle 9i release 1. Introduction of… Read More

Oracle 11g PL/SQL New Features

The tutorial lists the major PL/SQL additions and enhancements covered in Oracle 11g. The features described here are based on their utility in a development environment. SQL* Plus Stepped Down and Passwords made Case Sensitive SQL* Plus is no more the part of Oracle home family. This step has been taken to recommend the use of SQL Developer. SQL Developer version 3.0 is the latest release from Oracle, in which all the earlier reported bugs were resolved. Besides, developers can still optionally setup SQL* Plus environment on command line prompt.… Read More