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.

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.

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

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

How to look at the current sql*plus system settings?

1 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

1 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

How many types of privileges are available in sql?

1 Answers  

---

what is online transaction processing (oltp)? : Sql dba

1 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 Answers  

---

How do I find duplicates in a single column in sql?

1 Answers  

---

What are different methods to trace the pl/sql code?

1 Answers  

---

What are different categories of sql commands?

1 Answers  

---

What is varchar used for?

1 Answers  

---