What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 56475 Views
- I also Faced
- E-Mail Answers
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 record variable?
Is oracle sql free?
How can I get the number of records affected by a stored procedure?
What are tables and fields?
What are properties of the transaction?
What packages(if any) has oracle provided for use by developers?
which types of join is used in sql widely? : Sql dba
How show all rows in sql?
What are the different parts of a package?
How can you create an empty table from an existing table?
Can we update views in sql?
What is the difference between truncate and drop statements?
How to raise user-defined exception with custom sqlerrm ?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is an oracle stored procedure?
