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
how to join query for one source type is oracle another source type is sql server ?
How do I connect to oracle?
How to define an oracle sub procedure?
What is a static data dictionary in oracle?
How to add another datafile to a tablespace?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to use select statement to count the number of rows in oracle?
How to get a list of all background sessions in the database?
What is Undo Management Advisor in Oracle?
what is the use of system.effective.date variable in oracle?
What is bind variable in oracle 11g?
List the various oracle database objects?
How to write a query with a left outer join in oracle?
How to define a variable of a specific record type?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
