Answer / ganesh

anonymous is unnamed plsql block, cannot save in database,
cannot allow any mode of parameter.

stored programs are saved into database and we can recall
them whenever programe require it, it accept the mode of
parameter like
in,in out,out.

Answer / arun samal

Anonymous blocks are to be compiled each time when we
require it.But once we compile a named pl/sql block it is
permanently stored as p-code after compilation in the
shared pool of the system global area.
We can call named blocks by any pl/sql block that
appears within an application but we cannot call anonymous
blocks.

Answer / kavitha

An anonymous block is a pl/sql block that appears in your
application and is not named and stored in your database.

A stored procedure or a named block is a pl/sql block that
oracle stores in the database and can be called by name
from any application

Answer / amruta

Anonymous block: It does not have a name. Starts with
DECLARE or BEGIN.
Named block: Starts with Header Block.
like name of block, type of block, parameter.

Answer / raji_4u

1. Anonymous blocks are compiled each time they are executed,
where as stored subprograms compile only one time when they
are created.

2. Anonymous blocks are not stored in the database so they
can not be called from other blocks, where as stored
subprograms are stored in the database they can be called
from other blocks many times.

Answer / mohd mahmood ali

anonymous block is one which has name that starts: with
DECLARE, BEGIN...
Named Block has NAME: like PROCEDURE,FUNCTION,PACKAGES

Answer / ranjith

The anonymous block statement is an executable statement
that can contain PL/SQL control statements and SQL
statements. It can be used to implement procedural logic in
a scripting language.

named block or stored procedure is a pl/sql block that
oracle stores in the database and can be called by name
from any application
examples are function,procedure and packages,etc.....

Answer / tushar

annonymous block-it do not returns values
Named block-named block called function must returned values

How to take user input in pl sql?

0 Answers  

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

How many sql commands are there?

0 Answers  

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

Why are aggregate functions called so?

0 Answers  

what is meant by forward declaration in functions?

4 Answers   TCS,

What are the triggers associated with image items?

0 Answers  

When sql appeared?

0 Answers  

Can we have exception part in trigger ?

1 Answers  

Which command is used to delete a package?

0 Answers  

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers