Answer Posted / 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.

What is cascade in sql?

922

---

What is set serveroutput on in pl sql?

1219

---

How do you clear the screen in sql?

1020

---

how to use myisamchk to check or repair myisam tables? : Sql dba

923

---

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

971

---

Is sqlite thread safe?

999

---

What is difference between stored function and application function?

1120

---

what is unique key constraint? : Sql dba

1002

---

What is using in sql?

1027

---

How do you delete duplicates in sql query using rowid?

907

---

How do you write a complex sql query?

1016

---

how can we know the number of days between two given dates using mysql? : Sql dba

1003

---

What is an intersect?

1054

---

Does sqlite need a server?

1005

---

What are sql objects?

1030

---