Discussion in 'SQL PL/SQL' started by sita, Feb 8, 2014.
Read this and master pl/sql
With that document someone could learn the basics of PL/SQL but being 3 major releases behind current they won't master much. PL/SQL changed dramatically since 9i; the basic structure and functionality remain unchanged but additional functionality, such as forall and bulk collect, changed the PL/SQL landscape significantly. There is also AUTHID, which allows PL/SQL to use privileges granted by roles to the current user if AUTHID current_user is invoked in the procedure/function/package definition. This is nothing more than a basic beginning to PL/SQL and it should never be considered as a master class in the language.
Your advertising of the usefulness of this document is over-optimistic and borders on misinformation. Posting outdated material as new is wrong, on so many levels. Oracle no longer teaches this course with the materials you posted because they are severely outdated and have no benefit when teaching PL/SQL as found in the current releases.