What is the difference between anonymous block and named
blocks?

Answer Posted / anil kumar jampana

1)anonymous block will store in os
where as named block will store in database
2)we can call named block but not anonymous

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

discuss about myisam index statistics collection. : Sql dba

618


Explain cursor types?

664


Mention what plvcmt and plvrb does in pl/sql?

741


Why function is used in sql?

606


What programs use sql?

634






How do I run sql profiler?

684


How can triggers be used for the table auditing?

671


What does fetching a cursor do?

699


How do I create an index in word?

626


How can you load multi line records? : aql loader

726


How to process query result in pl/sql?

644


Why procedure is used in sql?

643


What is an exception in PL/SQL? What are the two types of exceptions?

732


What is autocommit sql?

627


What is the use of index in sql?

661