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
How to write text literals in oracle?
What is java oracle used for?
How to grant create session privilege to a user in oracle?
Which is faster join or subquery in oracle?
What is Reduced List of Values?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
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 oracle latest version?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Can you create a synonym without having a table?
How to insert a record into a table?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is varray?
How to see free space of each tablespace?
How to export your connection information to a file?
