Enhance the capabilities of SQL as PL/SQL allows mixing of SQL statements with procedural constructs. Unlike SQL, PL/SQL is a programming language extending SQL, which includes procedural elements like loops, data types, control structures and others.
You can create program blocks, functions, methods, triggers and packages with this extension. In simple terms, while SQL tells the relational database what to do, PL/SQL tells them how to do.
The main sections on language PL/SQL are:
1. DML Statements
2. Select Query
3. Table Joins
4. Stored Procedures
5. Functions
6. Collections and Records
7. Cursors
8. Exception Handling
9. Triggers
10. Views
11. Error Messages
Start learning Oracle PL/SQL from basics to advance levels here...
https://goo.gl/KMSUDC
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)