delete tab1 where (col1_dup,rowid) in (select col1

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / parthasarathi

Answer Posted / parthasarathi

delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

please send me forms, xml pulisher questions,answers

2160

What is sca and how is it useful?

1172

What is the concept of soa governance?

1320

What do you understand by soa?

1195

Do you know where we can check the status of po?

1361

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2158

where to define interorganization transaction charges and what are the different options?

2465

How do you register report in oracle apps?

1136

How to move the one file from one instance to another instance? And your scripts also?

1173

Can we create tables in apps schema?

1184

what is the differences between internal requisition and internal sales order?

2711

In support project one ticket alloted which steps follows manualy tell me ?

2711

Can you differentiate between mediator and osb?

1193

List the various types of value set.

1122

How many schemas we have? how many you have used?

2113