Oracle9i PL/SQL: Database Programming

This course discusses the features of stored subprograms and packages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces participants to database triggers: how to create them and their application to complement the capabilities of the Oracle base product.

Learn To

• Sequence the steps used to create stored subprograms by using iSQL*Plus.
• Identify the effects of storing code separately on the server and on the client.
• Perform the steps needed to create a stored procedure using iSQL*Plus.
• Match the Oracle server supplied packages with their uses.
• Identify the correct combinations of DBMS_PIPE subprograms and their uses.
• Identify the uses of the DBMS_DDL package.
• Identify the guidelines for using privileges that are related to a stored subprogram.
• Grant privileges on a stored subprogram by using SQL commands.
• Match the facilities available to manage stored subprograms with their application.
• Match the components of a database trigger with their descriptions.
• Identify the guidelines for designing triggers.
• Create a statement
• level database trigger by using iSQL*Plus.

Audience

The intended audience for this course includes Application Developers, Database Administrator, Tech Support Professionals.