PL/SQL

E97097
Oracle technology SQL extension procedural programming language

PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.

Jump to: Surface forms Statements Referenced by

Observed surface forms (1)

Surface form Occurrences
Oracle PL/SQL 2

Statements (49)

Predicate Object
instanceOf Oracle technology ⓘ
SQL extension ⓘ
procedural programming language ⓘ
basedOn Ada (programming language) ⓘ
surface form: Ada
designedFor Oracle Database ⓘ
relational database management ⓘ
developer Oracle Corporation ⓘ
documentationURL https://docs.oracle.com/en/database/oracle/oracle-database/ ⓘ
extends SQL ⓘ
hasComponent PL/SQL engine ⓘ
package body ⓘ
package specification ⓘ
hasFeature autonomous transactions ⓘ
bulk SQL operations ⓘ
dynamic SQL ⓘ
exception handling ⓘ
object-oriented extensions ⓘ
overloading of procedures and functions ⓘ
packages for code encapsulation ⓘ
triggers on tables and views ⓘ
integratesWith SQL ⓘ
introducedBy Oracle Database ⓘ
surface form: Oracle7
paradigm imperative ⓘ
procedural ⓘ
primaryUse ETL processes ⓘ
batch processing ⓘ
business logic implementation ⓘ
data validation ⓘ
server-side database programming ⓘ
runsIn Oracle Database ⓘ
surface form: Oracle Database server
supports anonymous blocks ⓘ
collections ⓘ
conditional statements ⓘ
control structures ⓘ
cursors ⓘ
exceptions ⓘ
loops ⓘ
modular programming ⓘ
packages ⓘ
records ⓘ
stored functions ⓘ
stored procedures ⓘ
triggers ⓘ
user-defined types ⓘ
supportsExecutionEnvironment Oracle Application Express ⓘ
Oracle Forms ⓘ
Oracle Reports ⓘ
usedWith Oracle Data Guard ⓘ
Oracle Real Application Clusters (RAC) ⓘ
surface form: Oracle Real Application Clusters

Referenced by (3)

Full triples — surface form annotated when it differs from this entity's canonical label.

PL/pgSQL → influencedBy → PL/SQL ⓘ
this entity surface form: Oracle PL/SQL
this entity surface form: Oracle PL/SQL