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 oracle server autotrace in oracle?
Use of an integrity constraint is better to validate data. Explain
Oracle
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are triggers in oracle?
How to use subqueries in the from clause in oracle?
How to find out what oracle odbc drivers are installed?
How to drop a tablespace?
Where do we use decode and case statements?
How to use in conditions in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is the difference between primary key and unique key and foreign key in oracle?
How to create id with auto_increment on oracle?
State and explain about oracle instance?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
