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 a hot backup and a cold backup in oracle?
Query to retrieve record for a many to many relationship ?
How to experiment a data lock in oracle?
How do you store pictures in a database?
Difference between varchar and varchar2 data types?
How to get the Installed Oracle Version Information ?
How do I uninstall oracle 11g?
What is the usage of control file in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Difference between hot backup vs. Cold backup?
How to delete all rows a table in oracle?
How to get last row id?
How different is ms access and oracle?
Who developed oracle & when?
Explain the use of record length option in exp command.