What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 55604 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 has stored procedures in sql?
What is the maximum database size for sql express?
What is the example of procedure?
what is top in tsql? : Transact sql
What are the sql versions?
tell me about various levels of constraint. : Sql dba
What is clustered index sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is the non-clustered index in sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What are procedures used for?
What is dml statement?
How do I send sql query results to excel?
How do you rename a table in sql?
Explain the rollback statement?
