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 can I introduce multiple conditions in like operator?
material view and view disadvantages?
What exactly do quotation marks around the table name do?
Write a syntax for update query in oracle?
Can we connect to ORACLE db using Windows Authentication?
How to drop a stored function?
What is Segment Advisor in Oracle?
State any two functions of oracle?
What privilege is needed for a user to create tables in oracle?
Will you be able to store pictures in the database?explain.
How to define a variable of a specific record type?
What is an oracle wallet?
Which is better Oracle or MS SQL? Why?
State and explain the different types of data models?
Explain the use of ignore option in imp command.
