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
- 59164 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 a trigger in sql?
Can you rollback after commit?
Why does sql need a server?
What does the base_object_type column shows in the user.triggers data dictionary view?
What does the acronym acid stand for in database management?
Is merge a dml statement?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is assignment operator in pl sql?
What is replication id?
What are the types of variables use in pl sql?
What is the mutating table and constraining table?
Write a query to display the current date in sql?
How to pipe multiline string to isql?
Explain the difference between triggers and constraints?
What is error ora-12154: tns:could not resolve the connect identifier specified?
