What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 56489 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
How would you pass hints to the sql processor?
what are the advantages and disadvantages of views in a database? : Sql dba
How do I create an index in word?
What is the difference between sum and count in sql?
what is the difference between blob and text? : Sql dba
how to select first 5 records from a table? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the best sql course?
What is the difference between nvl function, ifnull function, and isnull function?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is sql architecture?
How do I find sql profiler?
Explain what is a database?
What is sequence in sql?
What is localdb mssqllocaldb?
