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 tns service name?
What are the types of partitions in oracle?
Difference between pre-select and pre-query
What is a proxy object?
What is forall Statement ?
what is the difference between functional dependecy and multilevel dependency?
Explain an extent?
The join defined by the default data link is an outer join yes or no ?
can you write commit in triggers?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Is it possible to disable the parameter from while running the report ?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?