Q 3. What are the differences between SQL and PL/SQL ?
Ans: Some common differences between SQL and PL/SQL are as shown below:
| SQL is a query execution or commanding language | PL/SQL is a complete programming language |
| SQL is a data-oriented language. | PL/SQL is a procedural language |
| SQL is very declarative in nature. | PL/SQL has a procedural nature. |
| It is used for manipulating data. | It is used for creating applications. |
We can execute one statement at a
time in SQL. | We can execute blocks of statements in PL/SQL |
| SQL tells databases, what to do? | PL/SQL tells databases how to do. |
| We can embed SQL in PL/SQL. | We can not embed PL/SQL in SQL |
No comments:
Post a Comment