Posted On: Feb 22, 2018
PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ select/ updates/ delete. SQL is a query language that allows you to execute a single insert/ delete/ update. The following are the notable differences between SQL and PL/SQL:
|SQL is a data-oriented language which is very useful for interactive processing.||PL/SQL is a procedural language to create applications. It is an extension of Oracle.|
|SQL doesn’t have any procedural capabilities like condition testing, looping. It tells the database what to do and not how to do.||On the contrary, PL/SQL offers procedural capabilities like condition testing, looping, etc. it also offers high language features.|
|SQL is executed by the database one statement at a time. It is a time-consuming process.||PL/SQL is less time consuming as compared with SQL. It sends the block of codes to the database server at the same time.|
|There are very less chances of error handling in SQL.|
Never Miss an Articles from us.