Explain About The Process Which Takes Place To Execute A Stored Routi

1.	Explain About The Process Which Takes Place To Execute A Stored Routine?
Answer» CREATE PROCEDURE and CREATE FUNCTION statement are USED to create stored routine. It can act as a function or a procedure. A procedure can be called by using a CALL statement and pass output with the help of output VARIABLES. It can call other Stored routines and it can be called from the INSIDE of a statement. CREATE PROCEDURE and CREATE FUNCTION statement are used to create stored routine. It can act as a function or a procedure. A procedure can be called by using a call statement and pass output with the help of output variables. It can call other Stored routines and it can be called from the inside of a statement.

Explain About The Process Which Takes Place To Execute A Stored Routine?

Answer»

CREATE PROCEDURE and CREATE FUNCTION statement are USED to create stored routine. It can act as a function or a procedure. A procedure can be called by using a CALL statement and pass output with the help of output VARIABLES. It can call other Stored routines and it can be called from the INSIDE of a statement.

CREATE PROCEDURE and CREATE FUNCTION statement are used to create stored routine. It can act as a function or a procedure. A procedure can be called by using a call statement and pass output with the help of output variables. It can call other Stored routines and it can be called from the inside of a statement.

Discussion

No Comment Found

Related InterviewSolutions

Explain About The Return Statement?
Explain About The Implementation Of Stored Procedures?
If Get_product_name Is My Procedure Called In My Stored Procedure. Here In My Procedure I Am Passing A Value Directly But I Need To Pass The Value To The Procedure Dynamically. How It Is Possible?
State About The Security Aspects Of Stored Procedures?
Explain About Recursive Stored Procedures?
Explain About The Implementation Of Business Logic In Stored Procedures?
What Is The Difference Between A User Defined Function And A Stored Procedure?
What Are External Procedures ? Why And When They Are Used?
How One Call Ddl Statement Using Stored Procedures In Oracle?
Does Storing Of Data In Stored Procedures Increase The Access Time? Explain?