What are the blocks in stored procedure?

Answer Posted / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is transaction? : Sql dba

532


What is range partitioning?

522


What is the difference between sql and mysql?

561


What is the meaning of disabling a trigger?

649


How do I remove all records from a table?

570






Explain the uses of a database trigger?

575


What is the basic structure of an sql?

577


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1391


what is difference between delete and truncate commands? : Sql dba

582


What are predefined functions in sql?

535


what is a unique key ? : Sql dba

547


Write a sql query to find the names of employees that begin with ‘a’?

578


What is union and union all keyword in sql?

568


Enlist the characteristics of pl/sql?

1245


What is $$ in sql?

555