| Explanation |
: |
Stored procedure is a passive and connected /unconnected transformation.
- Create stored procedures to automate tasks that are too complicated for standard SQL statements.
- Stored procedures are stored and run within the database
- Stored procedures allow user-defined variables, conditional statements, and other powerful programming features.
|
| |
| DESIGNER :: |
| |
stored procedures to do the following tasks:
- Check the status of a target database before loading data into it.
- Determine if enough space exists in a database.
- Perform a specialized calculation.
- Drop and recreate indexes.
|
Stored Procedure
create or replace procedure
revised_sal(SAL in number, R_SAL OUT NUMBER)
is
begin
R_SAL:=SAL+1000;
END;
/
Template Appereance
|
SAL |
REV_SAL |
 |
|
|
|
