Interested to Buy Any Domain ? << Click Here >> for more details...
What are the blocks in stored procedure?
- 6 Answers
- 15514 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What is replication id?
How many types of cursors are available in pl/sql?
How can a pl sql block be executed?
List different type of expressions with the example.
What is java sql driver?
What is a join query?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is the importance of sqlcode and sqlerrm?
Explain the steps needed to create the scheduled job?
What is cost in sql execution plan?
How to create your own reports in sql developer?
What are the types of join and explain each?
What is sql and how does it work?
