PL/SQL Tutorial Part - 1

In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language.The basic difference between two languages is that SQL executes the single query at a time whereas, Pl/SQL executes the block of code at once. SQL is a Structured Query Language whereas, PL/SQL is a Procedural Language/ Structured Query Language.PL/SQL is an extension of Structured Query Language (SQL) that is used in Oracle. Unlike SQL, PL/SQL allows the programmer to write code in a procedural format. ... It combines the data manipulation power of SQL with the processing power of procedural language to create super powerful SQL queries.The PL/SQL is a procedural language that is an extension to the Oracle SQL or relational databases. ... In order to learn PL/SQL one should have basic knowledge of programming languages specifically be good on managing the SQL platform. Learning PL/SQL at your own pace might sometimes become complicated.The main feature of SQL (non procedural) is also a drawback of SQL: one cannot use control statements (decision-making or iterative control) if only SQL is to be used. PL/SQL is basically a procedural language, which provides functionality of decision making, iteration and many more features like other procedural programming languages. A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database