Answer Posted / edara satish

delete from
<<table_name>>
where rowid in
(select a.rowid
from <<table_name a,table_name b>>
where a.colname = b.colname
b.colname2 = b.colname2
......
...
a.colnamen = colnamen
order by .... desired colnames)

How to check the oracle tns settings?

1047

---

What are set operators?

1083

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1730

---

What is the use of oracle?

1030

---

What is the difference between truncate & delete command?

1183

---

What is dual table oracle?

985

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2468

---

What is the difference between $oracle_base and $oracle_home?

1089

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

---

How to Truncate Table in Oracle

1156

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

---

What are the components of logical database structure in oracle database?

1088

---

What is tns name?

981

---

How do I spool in oracle?

1005

---

Explain oracle’s server parameter file.

995

---