Thursday, September 15, 2011

PL/SQL

What is PL/SQL?


PL/SQL stands for Procedural Language extension of SQL.

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL.


The PL/SQL Engine:


Oracle uses a PL/SQL engine to processes the PL/SQL statements. A PL/SQL code can be stored in the client system (client-side) or in the database (server-side).

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle Escape Characters

Oracle allows the assignment of special escape characters to tell Oracle that the character is interpreted literally.  Certain characters ...

  • Columns to Rows
                        UNPIVOT (11g) Transforming columns into rows is easily accomplished with the SELECT command's UNPIVOT clause, intro...
  • Rows to Strings in Different Methods
    In this section show how to collect values from multiple rows into a single, delimited string. This process is commonly known as "strin...
  • Oracle Optimizer hint tips
    With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an  article ...