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 do I start sql from command line?

961

---

What is the difference between left join and right join?

887

---

How to take user input in pl sql?

1105

---

What is sql rowcount?

945

---

what are different types of keys in sql?

1063

---

How do you create a unique index?

985

---

Which table is left in left join?

951

---

Which normal form is best?

895

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1127

---

Explain the purpose of %type and %rowtype data types with the example?

924

---

What is mutating error?

906

---

Explain the difference in execution of triggers and stored procedures?

964

---

Is sql free?

883

---

Can I call a procedure inside a function?

942

---

Can we use update in sql function?

1003

---