What are the blocks in stored procedure?
Answer Posted / pronobesh
Actually there are 3 blocks
1) Declartion Block - Starts with AS right after CREATE
PROCEDURE <Proc Name>
2) Execution Block - Starts with BEGIN and ends with END
ahere the actual execution happen.
3) Exception Block - Where we catch the procedure error.
Hope this clarifies.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain lock escalation? : Transact sql
Why do we need databases?
What is data control language (dcl)?
What does data normalization mean?
what is table? : Sql dba
What are the uses of merge?
What is set transaction?
what is the functionality of the function htmlentities? : Sql dba
What is trigger in pl sql with examples?
Is sql difficult?
What's the difference between inner join and left join?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
How can you create an empty table from an existing table?
How run sql*plus commands that are stored in a local file?
Where is sql database stored?