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
- 58894 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 ? | 25 Yes | 4 No |
Post New Answer View All Answers
What is difference between db2 and sql?
What is difference between mysql and postgresql?
When you have to use a default "rollback to" savepoint of plvlog?
What is sql server and ase?
What is the plv (pl/vision) package offers?
what is a trigger? : Sql dba
What are analytic functions in sql?
Does group by remove duplicates?
What are the different types of a subquery?
how to shutdown mysql server? : Sql dba
How to disable a trigger name update_salary?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Can pl sql procedure have a return statement?
Mention what are the benefits of pl/sql packages?
What is the difference between cross join and natural join?
