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
what is transaction? : Sql dba
What is range partitioning?
What is the difference between sql and mysql?
What is the meaning of disabling a trigger?
How do I remove all records from a table?
Explain the uses of a database trigger?
What is the basic structure of an sql?
- 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?
what is difference between delete and truncate commands? : Sql dba
What are predefined functions in sql?
what is a unique key ? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
What is union and union all keyword in sql?
Enlist the characteristics of pl/sql?
What is $$ in sql?