Explain materialized views and how they are used.

2 Answers  

---

the user should know to which database he is connected currently in oracle

3 Answers  

---

Explain an ORA-01555

2 Answers  

---

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

---

How to find locks exists in a table or not?

1 Answers   HCL,

---

can u give guidance abt packages of plsql

0 Answers   Mphasis,

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

0 Answers   L&T,

---

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,

---

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---