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
What is group by in sql?
What is an inner join sql?
How do I view a procedure in sql?
what is the difference between undefined value and null value? : Sql dba
What is a database trigger?
Why do we create views in sql?
When is a declare statement required?
explain the difference between bool, tinyint and bit. : Sql dba
How to take user input in pl sql?
What is case function?
what is cross join? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
What's the difference between inner join and left join?
What is serial sql?
what is the difference between $message and $$message? : Sql dba