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

what are the balancing segments in AR?

2049

List the various types of value set.

1027

Do you know what are user profiles in apps. Any examples you can give?

1056

How to create a purchase order without a requisition?

1133

What are the Standard Reports and Forms in HRMS?

2240

In oracle application how do you debug or trace errors?

1061

What are the different components of soa suite?

1150

Plz anybody send me Technical specification for AP Interface

2511

What is the concept of soa governance?

1224

What is oracle soa suite?

1187

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2577

do you know is it possible to run the interface without using oracle apps?

1073

What is oracle soa suite and what are its different components?

1150

Can you explain the difference between architecture followed in 10g & 11g?

1025

Explain what are the tables of auto invoice?

1098