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 |
what is the syntax of CREATE command?
What is the scope of a local variable?
How to connect the oracle server as sysdba?
What is a synonym? What are its various types?
What is set operator oracle?
What is a parameter file in oracle?
What are transaction isolation levels supported by oracle?
What is Segment Advisor in Oracle?
When does a Transaction end ?
What is the difference between PFILE and SPFILE in Oracle?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Is primary key = unique key,not null? If yes,please explain IF No,please explain