|
Provided by: Serebra Learning Corporation Creating Stored Procedures and Functions |
 |
Training
Provided by Serebra Learning Corporation
To create and execute a stored function and call, and remove and view stored functions in PL/SQL Database administrators, application developers, and database operators
|
|
||||||||
Creating Stored Procedures and Functions
Audience
Database administrators, application developers, and database operators
Topics
Objectives
- Creating Stored Procedures and Functions
- create, remove, and view PL/SQL stored procedures.
- use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs.
- outline how to view values returned by OUT parameters.
- create stored procedures with suitable parameters.
- assign values to multiple parameters in a stored procedure and invoke that procedure.
- handle exceptions in stored procedures.
- execute a stored procedure in which you have assigned parameter values and handled exceptions.
- create and execute a stored function.
- call, remove, and view stored functions in PL/SQL.
- create, call, and remove stored functions in PL/SQL.
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
