Introduction to PL/SQL: Features, Differences, and Advantages
Classified in Computers
Written at on English with a size of 3.98 KB.
PL/SQL
PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variable of those types and triggers. It can support Array and handle exceptions (runtime errors).
Differences between SQL and PL/SQL
- SQL is a single query that is used to perform DML and DDL operations.
- PL/SQL is a block of codes that used to write the entire program blocks/ procedure/ function,