What is the difference between anonymous block and named
blocks?
Answer Posted / nagendra
anonymous block cannot be stored in database. it doesn't
contain name. it cannot be called for future use.
where as named block can be stored in database. it can be
named. it can be called for future use.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the usage of sql functions?
What is Difference Between Unique and Primary Key Constraints?
What is sharding in sql?
How do you determine the current isolation level? : Transact sql
What is sql in oracle?
What is index example?
What is t-sql? : Transact sql
Explain locks? : Transact sql
How to display the records between two range in Oracle SQL Plus?
What is sql lookup?
Why is normalization important?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is difference between cursor and trigger?
What is sql and db2?