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
Is left join and outer join same?
What is a constraint?
how to do backup entire database? : Transact sql
What is the use of function in sql?
Which join is like an inner join?
What is the use of triggers?
Can a foreign key have a different name?
Write a unique difference between a function and a stored procedure.
What does sign mean sql?
How to run sql*plus commands in sql developer?
Can a composite key be null?
How long does it take to learn pl sql?
How can a function retun more than one value in oracle with proper example?
How do I count records in sql?
How can we solve sql error: ora-00904: invalid identifier?