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 replication id?

935

---

Can we create foreign key without primary key?

985

---

Define the select into statement.

1057

---

How to know the last executed procedure?

1099

---

Why do we use view in sql?

962

---

How to move files from one directory to another in pl sql?

1195

---

What is the sql case statement?

1004

---

Is it possible to create startup or shutdown trigger for on-schema?

1029

---

What is sql trigger example?

1061

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1034

---

What is primary key sql?

1037

---

What is a subquery in sql?

1040

---

What is insert command in sql?

1128

---

how to include comments in sql statements? : Sql dba

956

---

What are the differences between implicit and explicit cursors?

1068

---