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.

Can procedure in package be overloaded?

610

---

What is sql query optimization?

545

---

What are the basic sql commands?

550

---

What are the different types of tables in sql?

485

---

Can function return multiple values in sql?

532

---

---

What are dml commands?

529

---

Mention what pl/sql package consists of?

539

---

What is the difference between a subquery and a join?

529

---

What is the requirement of self-join?

546

---

What is parallel hint?

750

---

Is ms sql traffic encrypted?

505

---

What are the triggers associated with image items?

619

---

What are the two different parts of the pl/sql packages?

566

---

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

533

---

How to return an array from java to pl/sql?

589

---