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)

What is the max number of columns in an oracle table?

948

---

How view is different from a table?

981

---

How can windows applications connect to oracle servers?

1005

---

what are actual and formal parameters?

1062

---

How to connect the oracle server as sysdba?

1030

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2151

---

What is an anonymous block?

1181

---

How to return top 5 rows in oracle?

1007

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1808

---

What is bind variable in oracle 11g?

1009

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2066

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

970

---

Is there any function in oracle similar like group_concat of mysql?

1006

---

Difference between hot backup vs. Cold backup?

953

---

Explain mutating triggers.

990

---