how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

How to create a stored function in oracle?

0 Answers  

---

---

How to define an anonymous block?

0 Answers  

---

defination of bitmap index

0 Answers   NIIT,

---

What is a Redo Log ?

3 Answers  

---

What is Data Block ?

2 Answers  

---

What happens if the update subquery returns multiple rows?

0 Answers  

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

How to bring a tablespace online?

0 Answers  

---