A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?
Answer / kriish
Views do no take memory in database they are just window through data is shown to user from table
| Is This Answer Correct ? | 17 Yes | 2 No |
how can we write trigger in trigger???????? can we write one trigger on two table???
What types of joins are used in writing subqueries?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
In Oracle 9i what does "i" Stands for?
master table and child table performances and comparisons in Oracle ?
Explain user account with reference to oracle.
Define oracle database
How to display the hierarchy of employee and managers without using connect by prior.
What are different Oracle database objects?
What is Redo Log Buffer in Oracle?
What is STATSPACK tool?
How to create a stored program unit?