PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. ... PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.
PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
» Prepare your enviornment
» Introducing Database Program Units
» Creating and Maintaining Packages
» Using System-Supplied Packages
» Creating and Maintaining Database Triggers
» Implementing System Event Triggers
» Work with Oracle database tools
» Understand and work work language features
» Work with DECLARE, BEGIN & EXCEPTION clause
» Understand and use nested blocks
» Use explicit cursors
» Database administrators
» Business users and non-technical senior end users