PL/SQL User’s Guide and Reference
Posted on 13:44 Hrs,March 7th, 2008 by admin

PL/SQL is Oracle’s procedural extension to SQL, the standard database access language. A full-fledged programming language, PL/SQL offers modern software engineering features such as data encapsulation, overloading, exception handling, and information hiding. PL/SQL also offers seamless SQL access, tight integration with the Oracle server and tools, portability, and security. Read the rest of this entry »

PL/SQL User’s Guide and Reference 10g
Posted on 15:57 Hrs,January 8th, 2008 by admin

The PL/SQL language is tightly integrated with SQL. You do not have to translate between SQL and PL/SQL datatypes: a NUMBER or VARCHAR2 column in the database is stored in a NUMBER or VARCHAR2 variable in PL/SQL.
Read the rest of this entry »