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.

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

describe transaction-safe table types in mysql : sql dba

0 Answers  

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

When is a declare statement required?

0 Answers  

what are null values? : Sql dba

0 Answers  

what are date and time functions in mysql? : Sql dba

0 Answers  

How are functions and procedures called in PL/SQL?

0 Answers  

What is the basic form of sql query?

0 Answers  

what is a stored procedure? : Sql dba

0 Answers  

What is the use of time stamp in select statement?

1 Answers   TCS,

what is sql.

7 Answers   Ericsson, Hewitt,