One of the most powerful features of the Oracle RDBMS product is the ability to create named 'blocks' of PL/SQL code that are stored within the database. This allows for robust solutions to be developed that can be shared and re-used. This intermediate class provides the technical expertise necessary to expand the powerful capabilities of PL/SQL by creating program units: stored procedures, functions, packages and triggers that are stored within the database. Working in Oracle's SQL Developer tool participants will learn how to develop, debug and manage all these types of programs. The four types of these program units: procedures, functions, packages and triggers are each covered in depth. Students will learn to write, debug and manage each. Students use the Oracle PL/SQL IDE, SQL Developer, throughout the course as the presentation tool and as their development environment. Features of this tool that enhance productivity along with its integral source level debugger are presented.
- Skill with GUI interfaces
- Data processing background
- Basic SQL and PL/SQL skill (3 to 6 months of development effort)
- A basic understanding of SQL is required to succeed in this class. The SQL used in this class is as simple as possible, but persons with absolutely no SQL experience will likely experience difficulty.
- An introductory understanding of PL/SQL is required to succeed in this class. The “Oracle 12c PL/SQL Introduction” (ORA-203-12) class contains this content.
3 Days/Lecture & Lab
This course is designed for Intermediate Oracle PL/SQL developers and DBAs supporting development tasks DBAs who want to automate repetitive database management tasks
- The Petsaver database
- Creating stored procedures
- Writing stored procedures using SQL Developer
- Creating stored functions
- Advanced features of procedures and functions
- 12c PL/SQL new features
- Debugging PL/SQL using SQL Developer
- Creating packages
- Writing packages with SQL Developer
- Advanced features of packages
- Creating database triggers
- Advanced features of triggers
- Maintaining program units
- Dynamic SQL in PL/SQL