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
What is oracle open database communication (odbc)?
What is difference between truncate and delete?
What is redo log?
what is normalisation?what are its uses?
What is coalesce function?
What do you mean by redo log file mirroring?
How do I connect to oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are the different pseudo commands? Explain in general?
How to open and close an explicit cursor in oracle?
What is bulk copy or bcp in oracle?
How to save query output to a local file?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is the maximum number of triggers that can be applied to a single table?
Why do we need oracle client?