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
What is raw datatype?
How to start your 10g xe server?
What is a schema in oracle?
How to experiment a data lock in oracle?
State any two functions of oracle?
How to write a query with an inner join in oracle?
What is the dynamic sql in oracle?
How to retrieve the count of updated rows?
How to declare a local variable?
Is oracle a relational database?
What is oracle rownum?
What is set operator oracle?
What is a sub query and what are the different types of subqueries?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain an exception?
