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
what are the types of join and explain each? : Sql dba
How delete a row in sql?
Why partition by is used in sql?
What is scalar and vector?
How do you determine the current isolation level? : Transact sql
How do you pronounce sql?
What is materialized view in sql?
What is scope of pl sql developer in future?
How would you convert date into julian date format?
Why is a trigger used?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is latest version of sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is the maximum number of triggers, you can apply on a single table?
What does fetching a cursor do?