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
- 58464 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 varchar sql?
what are null values? : Sql dba
How can you fetch common records from two tables?
What is java sql package?
Can there be 2 primary keys in a table?
What is the maximum database size for sql express?
What is the difference between the sql*loader and import utilities? : aql loader
Describe sql comments?
Can we use distinct and group by together?
Is sql difficult?
how can we find the number of rows in a table using mysql? : Sql dba
What is a data definition language?
What jobs use sql?
What is the usage of sql functions?
What is 19 null in sql?
