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 sql and explain its components?
How do I view tables in mysql?
Can you selectively load only those records that you need? : aql loader
what are the different functions in sorting an array? : Sql dba
What is rowid in sql?
Why function is used in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
Can you inner join the same table?
Is left join faster than inner join?
what are all types of user defined functions? : Sql dba
what is a table in a database ? : Sql dba
What is full join in sql?
define sql insert statement ? : Sql dba
Cite the differences between execution of triggers and stored procedures?
What is java sql package?