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
Explain a synonym?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is oracle sid?
How to create a stored procedure in oracle?
What happens to the current transaction if the session is ended?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Differentiate between function and procedure in oracle.
what are archived logs?
Explain a private synonyms?
What are ddl statements in oracle?
What is the use of oracle?
what is the dual table in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How to start your 10g xe server?
What is a partition in oracle?