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 are the different types of database management systems?
what is a database? : Sql dba
What is the example of procedure?
What are all types of user defined functions?
what are string data types? : Sql dba
What are the different sql languages?
Is a table valued function object?
What is bulk collect in pl sql?
How do I use google cloud in sql?
what is the bond code in materialized view?
Which version of sql do I have?
What is serial sql?
What is delimiter sql?
What is the command used to fetch first 5 characters of the string?
How to display Row Number with Records in Oracle SQL Plus?