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 a sql instance vs database?
What is dcl in sql?
What is the purpose of a secondary key?
What type of database is cloud sql?
Explain constraints in sql?
What is scalar function in sql?
What are the popular database management systems in the it industry?
What is join view in sql?
What is sqlerrm?
What is the difference between Union and Union all. Which is faster.
what is the difference between where clause and having clause? : Sql dba
What are crud methods?
How to test for null values?
what is the syntax used for partition in tsql? : Transact sql
What is trigger explain with example?