Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is the difference between anonymous block and named
block or stored procedure?

Answers were Sorted based on User's Feedback



What is the difference between anonymous block and named block or stored procedure?..

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.

Is This Answer Correct ?    52 Yes 3 No

What is the difference between anonymous block and named block or stored procedure?..

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

Is This Answer Correct ?    41 Yes 10 No

What is the difference between anonymous block and named block or stored procedure?..

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.

Is This Answer Correct ?    30 Yes 2 No

What is the difference between anonymous block and named block or stored procedure?..

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.

Is This Answer Correct ?    26 Yes 2 No

What is the difference between anonymous block and named block or stored procedure?..

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.

Is This Answer Correct ?    23 Yes 4 No

What is the difference between anonymous block and named block or stored procedure?..

Answer / mohd mahmood ali

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

Is This Answer Correct ?    7 Yes 2 No

What is the difference between anonymous block and named block or stored procedure?..

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

Is This Answer Correct ?    3 Yes 1 No

What is the difference between anonymous block and named block or stored procedure?..

Answer / tushar

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  


mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  


Define commit, rollback and savepoint?

0 Answers  


Which command is used to delete a trigger?

0 Answers  


Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,






what are the authentication modes in sql server? : Sql dba

0 Answers  


what is the use of friend function? : Sql dba

0 Answers  


What is a column in a table?

0 Answers  


what is text? : Sql dba

0 Answers  


Is and as keyword in pl sql?

0 Answers  


what is datawarehouse? : Sql dba

0 Answers  


What is a primary key sql?

0 Answers  






Categories