Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / janaka
Yes we can create Indexed view.
use
CREATE UNIQUE CLUSTERED INDEX i_IndexA
ON View_Name(field1,field2)
| Is This Answer Correct ? | 55 Yes | 35 No |
Post New Answer View All Answers
What are the differences between number and binary_float in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Why do we need integrity constraints in a database?
How do I connect to oracle database?
What is the difference between substr & instr functions?
What privilege is needed for a user to connect to oracle server?
How to sort the query output in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is oracle used for?
What is a subquery in oracle?
Explain the difference between replace() and translate() functions in oracle?
What is using clause and give example?
How to drop an existing table in oracle?
Which is better Oracle or MS SQL? Why?
