PL/SQL
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database.
Many customers allow client code to access Oracle Database only by calling PL/SQL subprograms. This approach not only reflects generic modular programming best practices (define a clean, functional API and hide the implementation); also, it typically drastically reduces network round trips between the client and Oracle Database.
PL/SQL is mission-critical not only for our Fortune 500 customers, but also for Oracle's E-Business Suite, which has over 20 million lines of PL/SQL code.
Server-side PL/SQL is fully available in all editions of Oracle Database; it needs no explicit installation or licensing.
|
|
 |
Learn More |
 |
Registration now open!
 |
Related Technologies |
 |
 |
Previous Releases |
 |
|