What is the difference between anonymous block and named
blocks?
Answer Posted / santosh kumar
anonymous block cannot be stored in database. it start with
"Declare" keyword can also contain name but that will be
temporary block. it only exist in the oracle work area for
during execution time after execution it destroy from the
memory. it cannot be called for future use.
but named block exist in the database and can be reusable.
we can call it any time it also called pl/sql database objects.
like......
procedure (it will exist in the "user_source") dictionary
view.
function (it will exist in the "user_source") dictionary
view.
package (it will exist in the "user_source") dictionary
view.
trigger (it will exist in the "user_triggers") dictionary
view.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can we enter data in a table in design view?
What is the maximum number of rows in sql table?
What is exception? What are the types of exceptions?
What is a sql driver?
Why schema is used in sql?
Explain sql data types?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
how do you login to mysql using unix shell? : Sql dba
What is serial sql?
How does join work in sql?
How to display the records between two range in Oracle SQL Plus?
What is the use of sqldataadapter?
Can we group by two columns in sql?
What is loop in pl sql?
How do you create a db file?