what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / vaibhavi_dixit
Anonymous block those pl/sql blocks which are not stored in
your DB as an objects, whereas named pl/sql blocks are
those blocks which are stored in DB as an objects.Due to
storage in DB, these named pl/sql blocks can be called from
another named or anonymous blocks, or from any form also...
Is This Answer Correct ? | 34 Yes | 2 No |
Post New Answer View All Answers
Explain the order of sql statement execution?
What is an invalid partition table?
What is a behavioral trigger?
What operators deal with null?
What is difference between table and view?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How do you sort in sql?
what are date and time functions in mysql? : Sql dba
Does sql between include endpoints?
What is the use of stored procedures?
What is nvarchar in sql?
how to include numeric values in sql statements? : Sql dba
What does count (*) do in sql?
What are field types?
How do you drop a trigger?