|
Creating Stored Procedures and Functions
(Duration: 2:50:00)
Price: $36.00
Course Code:
216563_eng
Course Catalog(s):
Course Provider:
SkillSoft
12 months
Description:
To create and execute a stored function and call, and remove and view stored functions in PL/SQL
Sections:
- • Creating stored procedures
- - create, remove, and view PL/SQL stored procedures.
- • Using parameter modes
- - use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs.
- • Viewing parameter values
- - outline how to view values returned by OUT parameters.
- • Creating stored procedures and parameters
- - create stored procedures with suitable parameters.
- • Executing procedures with multiple parameters
- - assign values to multiple parameters in a stored procedure and invoke that procedure.
- • Handling exceptions in stored procedures
- - handle exceptions in stored procedures.
- • Executing stored procedures
- - execute a stored procedure in which you have assigned parameter values and handled exceptions.
- • Developing stored functions
- - create and execute a stored function.
- • Controlling stored functions
- - call, remove, and view stored functions in PL/SQL.
- • Using stored functions
- - create, call, and remove stored functions in PL/SQL.
|