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

can a stored procedure call itself or recursive stored procedure? : Sql dba

578


What are the subsets of sql?

548


How does an execution block start and end in pl sql?

498


How to move files from one directory to another in pl sql?

642


What is the use of primary key?

537






What do you mean by stored procedures? How do we use it?

521


What is data abstraction in sql?

511


What is the difference between the conventional and direct path loads? : aql loader

693


What is the use of sqlerrd 3?

519


Is sql a dbms?

530


What is offset and limit in sql?

551


what is the difference between char_length and length? : Sql dba

572


Which are the different case manipulation functions in sql?

537


What are the types of variables use in pl sql?

507


What is a recursive join sql?

595