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 a temp table?

745

---

What if we write return in procedure?

972

---

How delete all records from table in sql?

719

---

what is meant by urlencode and urldocode? : Sql dba

768

---

What is the difference between inner join and natural join?

701

---

---

How to fetch alternate records from a table?

865

---

What is the starting oracle error number?

753

---

Does inner join remove duplicates?

699

---

Is primary key clustered or nonclustered?

739

---

which types of join is used in sql widely? : Sql dba

713

---

What has stored procedures in sql and how we can use it?

763

---

Explain exception handling in pl/sql?

725

---

what is 'mysqld'? : Sql dba

705

---

Does sql between include endpoints?

748

---

What is primary key and foreign key?

715

---