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
What is sql performance tuning?
What is cursor explain with example?
What is scalar function?
What are actual parameters and formal parameters?
what are the different index configurations a table can have? : Sql dba
What is the usage of nvl function?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is duration in sql profiler trace?
What is pl sql architecture?
How do you update a table in sql?
What is posting?
What is a clob in sql?
What is sql indexing?
what is a primary key? : Sql dba
What is cost in sql execution plan?