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 are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1019

---

what are the security recommendations while using mysql? : Sql dba

1094

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

945

---

what are local and global variables and their differences? : Sql dba

1053

---

How to use sql*plus built-in timers?

1168

---

What are the benefits of pl/sql packages?

1090

---

Can a key be both primary and foreign?

979

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

955

---

What are analytic functions in sql?

1007

---

what is an extent ? : Sql dba

1071

---

Explain some predefined exceptions.

1018

---

What are different types of indexes?

995

---

Does sql view stored data?

936

---

How can a function retun more than one value in oracle with proper example?

1061

---

how to decrement dates by 1 in mysql? : Sql dba

1006

---