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
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are the subsets of sql?
How does an execution block start and end in pl sql?
How to move files from one directory to another in pl sql?
What is the use of primary key?
What do you mean by stored procedures? How do we use it?
What is data abstraction in sql?
What is the difference between the conventional and direct path loads? : aql loader
What is the use of sqlerrd 3?
Is sql a dbms?
What is offset and limit in sql?
what is the difference between char_length and length? : Sql dba
Which are the different case manipulation functions in sql?
What are the types of variables use in pl sql?
What is a recursive join sql?