Answer / vaibhavi_dixit

Anonymous block those pl/sql blocks which are not stored in
your DB as an objects, whereas named pl/sql blocks are
those blocks which are stored in DB as an objects.Due to
storage in DB, these named pl/sql blocks can be called from
another named or anonymous blocks, or from any form also...

Answer / purushotham

Named pl/sql blocks are nothing but procedures.
procedures are compiled and stored in the database and
a user can call the procedure when required.
whereas anonymous are unnamed pl/sql blocks that will be
available for the time that is executed and it will not the
stored in the Database.

Answer / dev

YOU CAN NOT PASS PARAMETERS IN ANONYMOUS BLOCK
WHERE AS YOU CAN PASS IT IN NAMED PLSQL BLOCK.

YOU CAN CALL NAMED BLOCK FROM ANY DB(USING DB LINK)

Answer / mk

the purpose of an anonymous block is to write a one time
code e.g. you can write statements using SQL PLus editor and
accomplish database changes and do stuff which you can also
do by creating a procedure

Answer / amarnath

thanks mr: mk

Answer / amarnath

Thanks Dev.If any use ful stuff pls forword to me my id is
amar.rk359@gmail.com

Answer / amarnath

Yes, above and r correct, here one point to observe evry
one, what is the important of annonimous block, y oracle
provide us.
is any one provide correct ans for this??

Answer / debi

annonymous blocks are the blocks of code executed on the
client server where as the named block such as(stored
procedure and functions) are the block of code executed on
the database server.so once the code is executed on the
server so no need to compile it again when the user wants
to run it again.So the program execution is faster in case
of executing the named block.

Is vs as in pl sql?

0 Answers  

what is bdb (berkeleydb)? : Sql dba

0 Answers  

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

Is sql database free?

0 Answers  

Why do we use partitions in sql?

0 Answers  

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

How do we accept inputs from user during runtime?

0 Answers  

Write a query to display the current date in sql?

0 Answers  

Can we call procedure in select statement?

0 Answers  

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

what are tables and fields? : Sql dba

0 Answers  

Store procedure will return a value?

4 Answers   eMids,