Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between SQL and PL/SQL?

user-image
Question added by Nour Amoudi , System Engineer , Mercedes Benz (Daimler AG)
Date Posted: 2015/01/30
Deleted user
by Deleted user

SQL is mainly a query language that permits you to create a single query or execute a single update / delete / insert in your code. PL/SQL, on the other hand, is a programming language used in Oracle (hence the "PL" term). PL/SQL allows you to code a full functioning program while creating more than just a single update / delete / insert / select statement.

So, all in all, SQL is executed in one statement at a time; whereas, PL/SQL is executed as a block of code. We can embed or include SQL in a PL/SQL program; but, not vice versa.

More Questions Like This