Answer Posted / siva
no we cann't create an index on a view.why because view is
a virtual table.when u select the view it will get the data
from base(database)table.
view is a stored query.so we cann't
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
defination of bitmap index
How to rename an existing table?
What is a cursor variable?
How to return top 5 rows in oracle?
How to execute a stored program unit?
What is BBED in Oracle?
What is connection pool in oracle?
What is transport network substrate (tns) in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is private procedure oracle?
Explain alias?
Can objects of the same schema reside in different tablespace?
What is a nested table?
Explain the use of Merge statement in oracle 11g
Difference between hot backup vs. Cold backup?