What is the difference between anonymous block and named
blocks?
Answer Posted / nagendra
anonymous block cannot be stored in database. it doesn't
contain name. it cannot be called for future use.
where as named block can be stored in database. it can be
named. it can be called for future use.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Does truncate free space?
Which are the different case manipulation functions in sql?
What is the difference between sql and t sql?
Can we create foreign key without primary key?
Show the two pl/sql cursor exceptions.
What is sqlerrm?
What is the difference between union and union all command?
what are the authentication modes in sql server? : Sql dba
what is 'mysqlimport'? : Sql dba
What is query optimization in sql?
Is sql a dbms?
Which nosql database is best?
What does <> sql mean?
Are pl sql variables case sensitive?
Show how functions and procedures are called in a pl/sql block.