Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between anonymous block and named
blocks?
- 3 Answers
- 10615 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
What is the most common sql injection tool?
What is acid property in a database?
What are the different types of a subquery?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How do you add a column to a table?
Explain the rollback statement?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do I pipe the output of one isql to another?
What is substitution variable?
how to see the create table statement of an existing table? : Sql dba
What is trigger and stored procedure in sql?
give the syntax of grant and revoke commands? : Sql dba
How to create a menu in sqlplus or pl/sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is trigger in sql? Explain
