Stored Procedure3

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Stored Procedure : 

Stored Procedure

Stored Procedure Overview : 

Stored Procedure Overview Stored Procedure is a function in a shared library accessible to the database server

Slide 3: 

Applications using stored procedures

Writing Stored Procedures : 

Writing Stored Procedures CREATE OR REPLACE PROCEDURE <name> (<arglist>) AS <declarations> BEGIN <procedure statements> END Explicit parameter to be defined : IN: Passes a value to the stored procedure from the client application OUT: Stores a value that is passed to the client application when the stored procedure terminates. INOUT : Passes a value to the stored procedure from the client application, and returns a value to the Client application when the stored procedure terminates

Slide 5: 

Some Valid SQL Procedure Body Statements CASE statement FOR statement GOTO statement IF statement ITERATE statement RETURN statement WHILE statement

Slide 6: 


Advantages Of Stored Procedures : 

Advantages Of Stored Procedures Precompiled execution. Reduced client/server traffic Efficient reuse of programmed code and programming concept. Better security controls

summary : 

summary Stored Procedure Overview Writing Stored Procedures Some Valid SQL Procedure Body Statements Example for Valid Stored Procedure Advantages Of Stored Procedures

Slide 9: 

THANK YOU

authorStream Live Help