Answer / shams tabrez

Materialized views are dynamic views, means if materialized
were created on 2 tables than if any update happens in
these two tables than it reflect on materialized views
which is created on these 2 tables.

Answer / shyamal mondal

Materialized view is a database object which contains the result of a query. It is the local copy of data located remotely or are used to create summary table based on aggregation of table's data.

how to replace not in with not exist?

1 Answers   IBM,

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1 Answers  

---

What view would you use to determine free space in a tablespace?

1 Answers  

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---

Name three advisory statistics you can collect.

1 Answers  

---

i have marks in table,how to find total?

1 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

What is auto invoicing? Explain : oracle accounts receivable

1 Answers  

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

1 Answers  

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

What is the mandatory setup in cyclecount ?

1 Answers   Oracle,

---