what is the difernece between named and anonymous pl/sql blocks??

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

what is the difernece between named and anonymous pl/sql
blocks??

Question Posted / shekhar gour

8 Answers
21957 Views
TCS, Wells Fargo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difernece between named and anonymous pl/sql blocks??..

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

Is This Answer Correct ?

34 Yes

2 No

what is the difernece between named and anonymous pl/sql blocks??..

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.

Is This Answer Correct ?

8 Yes

1 No

what is the difernece between named and anonymous pl/sql blocks??..

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)

Is This Answer Correct ?

8 Yes

2 No

what is the difernece between named and anonymous pl/sql blocks??..

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

Is This Answer Correct ?

4 Yes

3 No

what is the difernece between named and anonymous pl/sql blocks??..

Answer / amarnath

thanks mr: mk

Is This Answer Correct ?

2 Yes

3 No

what is the difernece between named and anonymous pl/sql blocks??..

Answer / amarnath

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

Is This Answer Correct ?

1 Yes

2 No

what is the difernece between named and anonymous pl/sql blocks??..

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??

Is This Answer Correct ?

3 Yes

5 No

what is the difernece between named and anonymous pl/sql blocks??..

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 This Answer Correct ?

1 Yes

3 No

Post New Answer