Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 58828 Views
- I also Faced
- E-Mail Answers
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 ? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
What does count (*) mean?
List the different type of joins?
What are sql constraints?
Why do we use joins?
How do I write a sql query in pgadmin 4?
what is the stuff function and how does it differ from the replace function? : Sql dba
what is a database? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
What do you mean by stored procedures? How do we use it?
How to add, remove, modify users using sql?
Which is faster view or stored procedure?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
what is the difference between union and union all? : Sql dba
