The following comparison chart explains their main differences:
SQL |
PL/SQL |
SQL is a database structured query language used to communicate with relational databases. It was developed by IBM Corporations and first appeared in 1974. |
PL/SQL or Procedural Language/Structured Query Language is a dialect of SQL used to enhance the capabilities of SQL. Oracle Corporation developed it in the early 90's. It uses SQL as its database language. |
SQL is a declarative and data-oriented language. |
PL/SQL is a procedural and application-oriented language. |
SQL has no variables. |
PL/SQL can use variables constraints and data types. |
SQL can execute only a single query at a time. |
PL/SQL can execute a whole block of code at once. |
SQL query can be embedded in PL/SQL. |
PL/SQL cannot be embedded in SQL as SQL does not support any programming language and keywords. |
SQL can directly interact with the database server. |
PL/SQL cannot directly interact with the database server. |
SQL is like the source of data that we need to display. |
PL/SQL provides a platform where SQL data will be shown. |
Answers (0)