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

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

What are the limitations of sql express?

0 Answers  

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

Can we create view in stored procedure?

0 Answers  

---

find the third highest salary?

23 Answers  

---