Introduction to PL/SQL:

This lesson deals with the (PL) Procedural Language extension to SQL, its benefits in the programming aspect and the complete architecture of PL/SQL. This lesson also deals with several controls structures and Iterative control statements.

• Introduction to PL/SQL
• Architecture of PL/SQL
• Different types of Blocks
• PL/SQL Delimiters
• Writing simple programs
• Working with Control Structures
• Using Loop statements

An Oracle's PL/SQL is a procedural language extension of SQL. Pl/SQL is the standard programming language for Oracle RDBMS and follows the procedural approach.  It also gives conditional constructs like IF.. THEN, WHILE LOOP that are available in other languages such as C, Pascal, COBOL.PL/SQL is very powerful as it combines the flexibility available in SQL with the procedural constructs.  An Oracle's PL/SQL adds a lot of further capabilities to Oracle programming in order to do validations, customization, involved user interfaces and handling errors efficiently.