PL/SQL

Short Description
This section will provide a basic understanding of PL/SQL. … With PL/SQL, you can use SQL statements to manipulate ORACLE data and flow-of-control …

Website: www.javaprogrammingworld.com | Filesize: 84kb

Content
1
PL/SQL
This section will provide a basic understanding of PL/SQL. This document will briefly cover the main concepts behind
PL/SQL and provide brief examples illustrating the important facets of the language. Most of the information contained
in this section is DIRECTLY extracted from ”PL/SQL User’s Guide and Reference” and all credit should be given to
ORACLE. If you require more detailed information than provided in this section, consult the above stated manual.
PL/SQL is Oracle’s procedural language extension to SQL, the relational database language. PL/SQL fully integrates
modern software engineering features such as data encapsulation, information hiding, overloading, and exception
handling, and so brings state-of-the-art programming to the ORACLE Server and a variety of ORACLE tools.
Overview of PL/SQL
With PL/SQL, you can use SQL statements to manipulate ORACLE data and flow-of-control statements to process the
data. Moreover, you can declare constants and variables, define subprograms (procedures and functions), and trap
runtime errors. Thus, PL/SQL combines the data manipulating power of SQL with the data processing power of
procedural languages.
PL/SQL is a block-structured language. That is, the basic units (…