What is the difference between SQL and PL/SQL?
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. |
0 Answers
0Be the first to answer this interview question.
Your Answer
Sign in to post your answer and help the community.