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

what is collation? : Sql dba

610


how can we repair a mysql table? : Sql dba

536


What is faster join or subquery?

506


How can triggers be used for the table auditing?

592


Why use triggers in sql?

496






Is it possible to create the following trigger: before or after update trigger for each row?

718


Why truncate is used in sql?

527


What is the difference between sql and mysql?

549


What are the topics in pl sql?

514


How many sql statements are used?

564


What is db journal file?

516


what is the difference between clustered and non clustered index in sql? : Sql dba

545


what is the difference between union and union all? : Sql dba

544


What is difference between rank () row_number () and dense_rank () in sql?

575


Is sql free?

499