Answer Posted / deepak
We can create indexes on materialised views
| Is This Answer Correct ? | 48 Yes | 7 No |
Post New Answer View All Answers
What are the oracle differences between nvl and coalesce
How to count duplicated values in a column in oracle?
Is primary key indexed by default in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to rebuild an index in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the disadvantage of User defind function?
What are the ansi data types supported in oracle?
How to get a create statement for an existing table?
Where do we use decode and case statements?
What is the difference between I and G in Oracle?
How to export your own schema?
Explain about the analyze command in oracle?
How to rename a column in an existing table?