Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dibya tara shakya
No we cannot create index in views. As view are virtual
table based on multiple or single static tables.
View are create and execute only if there is select
privilege in base table to create view .
Triggers are also create in views.
But we can treat a view a table which make ease to gather
the data from different tables. we can insert data from
views only if the view are created from single table.
| Is This Answer Correct ? | 23 Yes | 34 No |
Post New Answer View All Answers
What is the difference between online and offline backups?
How to define an external table with a text file?
IS it possible to built the oracle database without setting the kernal parameters?
How to rollback the current transaction in oracle?
What are a cluster and non-cluster index?
Can you tell me how to add new column in existing views?how?How is possible?
In the oracle version 9.3.0.5.0, what does each number shows?
How to use "for" statements in oracle?
What are the original export and import utilities?
What is the dynamic sql in oracle?
How to export your own schema?
What are the logical operations?
What is tns service name?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to assign a tablespace to a users in oracle?
