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
What is hibernate and its relation to sql?
Does truncate need commit?
what happens if null values are involved in expressions? : Sql dba
How do I create a sql script?
How do I run pl sql in sql developer?
How exception handling is done in advance pl/sql?
How to run sql commands in sql*plus?
Can a commit statement be executed as part of a trigger?
Is sqlite good enough for production?
what are the authentication modes in sql server? : Sql dba
What is the syntax and use of the coalesce function?
What is the use of partition by in sql?
How to add a column ‘salary’ to a table employee_details?
Do we need commit after truncate?
What are the differences between in and exists clause?