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


Please Help Members By Posting Answers For Below Questions

how would you enter characters as hex numbers? : Sql dba

516


What is rownum and rowid?

564


What is the difference between a primary key and a clustered index?

518


What are the most important characteristics of pl/sql?

573


what is primary key? : Sql dba

510






Which is better join or subquery?

604


What is nvarchar in sql?

520


What are secondary keys?

557


What is sharding in sql?

561


Can we group by two columns in sql?

501


How do I edit a stored procedure?

552


What is raw datatype in sql?

548


What does (*) mean in sql?

527


How to return multiple rows from the stored procedure?

518


Why we use join in sql?

526