What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / 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 ? | 33 Yes | 2 No |
Post New Answer View All Answers
What is a unique key and primary key and foreign key?
What are the advantages of sql?
What is meant by cursor in sql?
What are the advantages of normalization?
Explain exception handling in pl/sql?
What is a design view?
What is t-sql? : Transact sql
what is a database lock ? : Sql dba
What is the syntax to add a record to a table?
is it possible to pass an object or table to a procedure as an argument?
How show all rows in sql?
What is a join query?
what happens if you no create privilege in a database? : Sql dba
What are the features of pl sql?
Is sql harder than python?