| |
|
| |
Creating Stored Procedures and Functions Training Class |
|
| |
|
|
| |
|
|
| |
Creating Stored Procedures and Functions Training Seminar
To create and execute a stored function and call, and remove and view stored functions in PL/SQL
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
US$ 74.95
|
|
| |
|
|
| |
Agenda |
|
| |
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.
|
|
|
| |
|
|
| |
Audience |
|
| |
Database administrators, application developers, and database operators
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|