Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhoosapre
An index cannot be defined on a view. Because view is
virtual table, which consists of a subset of columns from
one more tables.
The Restrictions imposed on views are as follows:
1. A view can be created only in the current database.
2. A view can be created only if there is a SELECT
permission on its base table
3. A Trigger or an Index cannot be defined on a view.
4. A view cannot be derive its data from temporary tables.
5. The CREATE VIEW statement cannot be combined with other
SQL statements in a single batch.
| Is This Answer Correct ? | 144 Yes | 67 No |
Post New Answer View All Answers
How to add a new column to an existing table in oracle?
What is hash cluster in oracle?
Give the various rollback segment states.
How to put more than 1000 values into an oracle in clause?
Explain joins in oracle?
What is a sub query? What are its various types?
What is the difference between alert log file and tarce file ?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain a segment?
What is the difference between $oracle_base and $oracle_home?
How to pass parameters to procedures?
Define oracle database
Explain the use of tables option in exp command.
How to run create database statement again?
What are the arithmetic operations?
