Answer / 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.

Answer / nagendra

anonymous block cannot be stored in database. it doesn't
contain name. it cannot be called for future use.

where as named block can be stored in database. it can be
named. it can be called for future use.

Answer / anil kumar jampana

1)anonymous block will store in os
where as named block will store in database
2)we can call named block but not anonymous

Explain the select statement in sql?

0 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

What are the different operators available in sql?

0 Answers  

---

What is program debugging?

0 Answers  

---

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

What is the purpose of design view?

0 Answers  

---

What is the difference between left join and left outer join?

1 Answers  

---

How many types of relationship are there?

0 Answers  

---

What is faster join or subquery?

0 Answers  

---