What are the blocks in stored procedure?
- 6 Answers
- 13939 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 the use of nvl function?
How do I run a pl sql program?
What is the main reason behind using an index?
How would you reference column values before and after you have inserted and deleted triggers?
Why is normalization important?
What are the two different parts of the pl/sql packages?
Which sorts rows in sql?
Can we perform dml on view?
Which join is like an inner join?
What is a ddl command?
What is sql*loader and what is it used for?
What is sql deadlock?
what are myisam tables? : Sql dba
What is the difference between drop and truncate commands?
Is it mandatory for the primary key to be given a value when a new record is inserted?
