What is the difference between anonymous block and named blocks?

What is the difference between anonymous block and named
blocks?

Question Posted / swapna

3 Answers
9629 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between anonymous block and named blocks?..

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

What is the difference between anonymous block and named blocks?..

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

What is the difference between anonymous block and named blocks?..

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

Post New Answer