What is the difference between anonymous block and named
blocks?
Answers were Sorted based on User's Feedback
Answer / santosh kumar
anonymous block cannot be stored in database. it start with
"Declare" keyword can also contain name but that will be
temporary block. it only exist in the oracle work area for
during execution time after execution it destroy from the
memory. it cannot be called for future use.
but named block exist in the database and can be reusable.
we can call it any time it also called pl/sql database objects.
like......
procedure (it will exist in the "user_source") dictionary
view.
function (it will exist in the "user_source") dictionary
view.
package (it will exist in the "user_source") dictionary
view.
trigger (it will exist in the "user_triggers") dictionary
view.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / anil kumar jampana
1)anonymous block will store in os
where as named block will store in database
2)we can call named block but not anonymous
Is This Answer Correct ? | 3 Yes | 1 No |
how to get second highest salary in SQL(as/4000
what is definer rights invoke rights?
How to run sql statements with oracle sql developer?
how u can find the n row from a table?
write a query to display diference between two dates in sql server
what are the advantages of mysql in comparison to oracle? : Sql dba
What does stand for in sql?
What does count (*) mean in sql?
How to load data with sql*loader?
What is pivot table in sql?
What are the usage of SAVEPOINTS?
why should required for Indexed by table in pl/sql