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 are all the different normalizations?
What is user in sql?
What are the parts of a sql statement?
Is natural join same as inner join?
How to run sql statements with oracle sql developer?
What is the most important ddl statements in sql are?
what are the join types in tsql? : Transact sql
Can we create clustered index without primary key?
Is json a nosql?
Is primary key always clustered index?
What is raid? How does it help storage of databases?
How many types of triggers exist in pl/sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How to get each name only once from an employee table?
What is a behavioral trigger?