COMPILER DESIGN

Detailed explanation-1: -SQL is an ANSI-compliant, nonprocedural, fourth-generation programming language. PL/SQL is an Oracle proprietary, procedural, third-generation programming language.

Detailed explanation-2: -PL/SQL (Procedural Language SQL) is the proprietary extension to SQL for Oracle’s DBMS systems, a procedural language tightly integrated with both SQL and Oracle databases.

Detailed explanation-3: -PL/SQL is Oracle’s procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural constructs. PL/SQL provides the capability to define and execute PL/SQL program units such as procedures, functions, and packages.

Detailed explanation-4: -PL/SQL is a proprietary language not available outside the Oracle Database. It is a third-generation language (3GL) that provides programming constructs similar to other 3GL languages, including variable declarations, loops, error handling.

Detailed explanation-5: -Non-procedural languages such as SQL, Oracle, postscript, Informix 4GL are considered as fourth-generation languages. This type of language allows the user to define “what is required” rather than “how it is to be done". These are designed to reduce the overall time, effort, and cost of software development.