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
definition of cluster and non-clustered index?
How to connect to a local oracle 10g xe server?
How do you store pictures in a database?
How to loop through data rows in the implicit cursor?
what are the default admin accounts in Oracle 10g ?
What is the meaning of recursive hints in oracle?
Where do you use decode and case statements?
How does oracle handle read consistency?
What are the limitations of check constraint?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Explain the types of exception?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is rowid and rownum in oracle?
How to display employee records who gets more salary than the average salary in the department?
Explain the importance of .pll extension in oracle?
