Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / siva
no we cann't create an index on a view.why because view is
a virtual table.when u select the view it will get the data
from base(database)table.
view is a stored query.so we cann't
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to delete a user account in oracle?
What do you mean by merge in oracle and how can you merge two tables?
What are the ways tablespaces can be managed and how do they differ?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Which is better Oracle or MS SQL? Why?
what are the advantages of running a database in archive log mode?
Explain the use of show option in imp command.
What is a server parameter file in oracle?
Can you have more than one content canvas view attached with a window ?
What is the simplest tool to run commands on oracle servers?
How do you find current date and time in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What the is the diff between local index and global index. give some example.
How data locks are respected in oracle?
What happens to the data files if a tablespace is dropped?
