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 get execution path reports on query statements?
How to define an oracle sub procedure?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is rich query?
Explain what are the type of synonyms?
How many data types are supported?
What privilege is needed for a user to connect to oracle server?
What do you mean by group by clause?
Can a parameter be passed to a cursor?
Explain oracle insert into command?
Explain parameter file in oracle.
How to create a new view in oracle?
what is the difference between data migration and production migration.
Difference between the “verify” and “feedback” command?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
