Oracle PL/SQL More than Basic and Less than Advanced.
An Introduction to PL/SQL:
So, what is PL/SQL? It is the procedural (and sometimes object-oriented) programming extension to SQL, provided by Oracle. The PL in PL/SQL stands for procedural language (PL) superset of the Structured Query Language (SQL). PL/SQL is a proprietary language not available outside the Oracle Database. It is a third-generation language (3GL) that provides programming constructs similar to other 3GL languages, including variable declarations, loops, error handling, etc. You can use PL/SQL to do such things as codifying your business rules through the creation of stored procedures and packages, trigger database events to occur and add programming logic to the execution of SQL commands. Structured Query Language (SQL).
The SQL in PL/SQL stands for structured query language. We use SQL to SELECT, INSERT, UPDATE and DELETE data. We use it to create and maintain objects and Schemas to control access rights to our instances. It actually grew out of the work done by Dr. E.F. Codd and IBM in the early 1970s. The American National Standards Institute (ANSI) recognizes SQL and publishes standards for the language.
It's Free Click Here to Download .pdf File
Hope It will be useful for you Guys, Thank You!!!
