Difference between SQL and PL/SQL?

Posted by silpa on Sep 11 2007

SQL(Structured Query Language) composed of DML and DDL
DML(Data Manipulative Language) consists of selete,update,insert,delete,merge
DDL(Data Definition Language) consists of create,alter,drop

data oriental language for selecting and manipulating data
SQL may be like source of data for a web page

PL/SQL
procedural language that extends SQL used for application development
language used to format,build and display web page

SQL statements allowed in pl/sql are DML only

Leave a Comment