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 the difference between left and left outer join?

957

---

Is vs as in pl sql?

995

---

Explain clause in sql?

1036

---

Why do we need cursors in pl sql?

1094

---

What is the left table in sql?

975

---

Does execute immediate commit?

1224

---

What is using in sql?

1099

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1013

---

Can you have more than one key in a database?

945

---

Is primary key clustered index?

955

---

what is a cursor? : Sql dba

1032

---

Explain the rollback statement?

1016

---

What is sql clause?

1057

---

Can we rollback truncate?

1008

---

What is sql*loader and what is it used for?

1159

---