Interested to Buy Any Domain ? << Click Here >> for more details...
What are the blocks in stored procedure?
- 6 Answers
- 15311 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / manojbatra071
whenever we create stored procedure the syntax is:
CREATE OR REPLACE PROCEDURE proc_name
AS/IS
(declare variables inside this block)
BEGIN
perform whatever u want in stored procedure
EXCEPTION
(perform the steps if any errors occur than what to do )
END;
therefore the blocks are as/is , begin,exception and end
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is trigger in flip flop?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is interval partition?
What are the benefits of triggers?
What is gpt format?
What is a left join?
what are wild cards used in database for pattern matching ? : Sql dba
What are the qualities of 2nf?
Explain polymorphism in pl/sql.
How do I partition in sql?
Can a table contain multiple primary key’s?
What is bulk compiling in pl/sql.?
How to avoid using cursors?
What is scalar and vector?
What is on delete set null?
