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 establish administrator authentication to the server?
How to write date and time literals in oracle?
How to create lov dynamically at runtime & attach to text field?
What is materialized view in Oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is difference between cartesian join and cross join?
What is a snapshot in oracle database?
Can you create a synonym without having a table?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is a server parameter file in oracle?
How to rename an index in oracle?
How to start your 10g xe server?
What are the uses of linked server and explain it in detail?
What are the data types in oracle?
Why do we use bulk collect in oracle?
