CodesJava

Easy learning with example program codes

what are the differences between sql and pl/sql?

SQLPL/SQL
It is a query execution or commanding languageIt is a complete programming language
It is data oriented languageIt is a procedural language
It is declarative in natureIt is procedural in nature
It is used for manipulating dataIt is used for creating applications
We can execute one statement at a time in SQLWe 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 programWe can not embed PL/SQL in SQL statement

Related topics

Please follow and like us:
error
Posted in SQL   








Copyright © 2019 CodesJava DMCA.com Protection Status