pl/sql

PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7), Times Ten in-memory database (since version 11.2.1), and IBM Db2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (run-time errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
Historically, the first public version of PL/SQL definition was in 1995, and the Oracle's inception year ~1992. It implements the ISO SQL/PSM standard.

You do not have permission to view the full content of this post. Log in or register now.
  1. X

    PL/SQL

    Hi! meron po ba kayong tutorials for PL/SQL? Thanks in advance.
  2. R

    PL/SQL/UNIX Banking Application (Help)

  3. P

    Closed Removing dark spot

    ano pong product ang makakawala ng darkspot sa mukha?
  4. D

    Closed Learn how to code from basic to hard coding

    Treehouse: HTML, CSS, PHP, JS, and Python Development Courses Check out all the topics Treehouse has to offer: CSS3, HTML5, Ruby, JavaScript, iOS, Photoshop, and more. Learn to Code - for Free | Codecademy Codecademy is the easiest way to learn how to code. It's interactive, fun, and you can...
Top