Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between anonymous block and named
blocks?
- 3 Answers
- 10764 Views
- I also Faced
- E-Mail Answers
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
Why do we create views in sql?
What is the use of stored procedures?
What is t-sql? : Transact sql
How does left join work in sql?
Name three sql operations that perform a sort.
What do you mean by field in sql?
How show all rows in sql?
Can I call a procedure inside a function?
What is the difference between function and procedure in pl/sql?
what is a control file ? : Sql dba
what is data manipulation language? : Sql dba
How do I truncate a sql log file?
How do I make sql search faster?
What are tables in sql?
What is the purpose of using pl/sql?
