Simply SQL is a data oriented language for selecting and manipulating sets of data while PL/SQL is a procedural language to create applications. SQL is composed of DML and DDL while PL/SQL is composed of declared variables and looping keywords like While,IF-ELSE etc.
Other difference is Sql as the name suggest it is just structured query language whereas PLSQL is a combination of Programming language & SQL.
PL/SQL can be the application language just like Java or PHP can. SQL may be the source of data for your screens, web pages and reports.
The code that makes our program function is PL/SQL. The code that create datasource(Table) and manipulates the data is SQL DML. PL/SQL may call SQL to perform data manipulation.
The commands that format the output of a tool are not related to the SQL standard or to PL/SQL.
No comments:
Post a Comment