CodesJava

Easy learning with example program codes

what are the differences between sql and pl/sql?


SQL PL/SQL
It is a query execution or commanding language It is a complete programming language
It is data oriented language It is a procedural language
It is declarative in nature It is procedural in 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 block of statements in PL/SQL
SQL tells database, what to do, not how to do it.? PL/SQL tells database how to do.
We can embed SQL in a PL/SQL program We can not embed PL/SQL in SQL statement

Related topics

Posted in SQL   


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap