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 to find 3rd highest salary of an employee from the employee table in sql?

788


Is inner join faster than left join?

874


What is insert command in sql?

770


What is database migration?

696


What is consistency?

886






Which is faster count (*) or count 1?

757


When to use inner join and left join?

695


What types of commands can be executed in sql*plus?

764


How to run sql*plus commands in sql developer?

800


How do I view a sql database?

749


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3309


How to connect a sql*plus session to an oracle server?

819


What is mutating table error?

882


What is auto increment in sql?

823


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

807