Answer Posted / mahesh kumar
we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why is oracle used?
How to use "in out" parameter properly?
What do you mean by a tablespace?
Can we connect to ORACLE db using Windows Authentication?
What is oracle join syntax?
What are triggers in oracle?
What is query image?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Describe varray?
What is a nested table and how is it different from a normal table?
How to experiment a data lock in oracle?
Explain what are clusters?
Can we protect our pl/sql source code?
What are the different editions of oracle?
What are the uses of Database Trigger ?