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.

How to make a copy values from one column to another in sql?

1078

---

What is a null value?

1186

---

What are % type and % rowtype?

1081

---

Are stored procedures compiled?

980

---

What are types of exception?

959

---

How do I restart sql?

1022

---

Which join condition can be specified using on clause?

1008

---

How are functions and procedures called in PL/SQL?

1306

---

What is the use of partition by in sql?

1043

---

What are the different operators available in sql?

1057

---

What is information schema in sql?

1113

---

What is the difference between functions, procedures, and packages in pl/sql?

1089

---

Why is there a need for sqlcode and sqlerrm variables?

1101

---

What are the advantages of stored procedure?

1037

---

what is meant by nl2br()? : Sql dba

1105

---