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
How is use pl and sql?
what is the difference between primary key and unique key? : Sql dba
What is graph sql?
What are the types of subqueries?
How do I run a pl sql procedure in sql developer?
What is parallel hint?
what's the difference between a primary key and a unique key? : Sql dba
Is pl sql a scripting language?
What is the use of count (*) in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do you write an index?
what happens if null values are involved in expressions? : Sql dba
What is natural join in sql?
What is composite primary key in sql?
How to fix oracle error ora-00942: table or view does not exist