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
How to find 3rd highest salary of an employee from the employee table in sql?
Is inner join faster than left join?
What is insert command in sql?
What is database migration?
What is consistency?
Which is faster count (*) or count 1?
When to use inner join and left join?
What types of commands can be executed in sql*plus?
How to run sql*plus commands in sql developer?
How do I view a sql database?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How to connect a sql*plus session to an oracle server?
What is mutating table error?
What is auto increment in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba