What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / amruta
Anonymous block: It does not have a name. Starts with
DECLARE or BEGIN.
Named block: Starts with Header Block.
like name of block, type of block, parameter.
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
Explain select statements in sql?
What is clause?
What is db journal file?
How do you optimize a query?
Does db2 use sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How many tables can a sql database have?
How can you tell the difference between an index and a view?
what are the differences between require and include, include_once and require_once? : Sql dba
What is procedure and function?
What is meant by truncate in sql?
How to Declare Fixed Length String Value In PL SQL
How do I access sql anywhere database?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is attribute indicator in pl sql?