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

What is foreign key and example?

0 Answers  

---

How can we link a sql database to an existing android app?

0 Answers  

---

How do you select unique values in sql?

0 Answers  

---

What is using in sql?

0 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  

---

Can we call procedure in select statement?

0 Answers  

---

Does varchar need length?

0 Answers  

---

What are the types of index in sql?

0 Answers  

---

What is the source code of a program?

0 Answers  

---