Answer / gautam choudhury

It's important to note that init.ora parameters
query_rewrite_integrity and query_rewrite_enabled are
required to use materialized views and function-based
indexes. if these two parameters are declared then hint is
not required to access a materialized view.

QUERY_REWRITE_INTEGRITY =ENFORCED
QUERY_REWRITE_ENABLED = TRUE

There are three acceptable values for
query_rewrite_integrity:

enforced (default) - Presents materialized view with fresh
data

trusted - Assumes that the materialized view is current

stale_tolerated - Presents materialized view with both
stale and fresh data

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1 Answers  

---

what is data abstraction

3 Answers   Semantic Space,

---

How to get execution path reports on query statements?

1 Answers  

---

How to use like conditions in oracle?

1 Answers  

---

What is the database name in oracle?

1 Answers  

---

How to install oracle odbc drivers?

1 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

Respected sir, Please send me technical questions related to oracle apps..

1 Answers  

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1 Answers   Oracle,

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

What is data block in Oracle?

1 Answers   MCN Solutions,

---