DELETE FROM EMP E1 WHERE E1.ROWID>(SELECT MIN(E2.ROWID)

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

Question Posted / ajith

Answer Posted / ajith

DELETE FROM EMP E1
WHERE E1.ROWID>(SELECT MIN(E2.ROWID)
FROM EMP E2
WHERE E1.EMPNO=E2.EMPNO)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you differentiate between mediator and osb?

1142

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

2069

What is a flexfield? List out its types.

1170

what are the balancing segments in AR?

2101

How to create a purchase order without a requisition?

1197

In oracle application how do you debug or trace errors?

1115

testing tools?

2254

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2219

Are you familiar with internet architecture of oracle apps 11i?

1068

Do you know what is applysys in oracle application database schema, what is apps?

1177

what is the difference between request group and request security in oracle apps?

5898

What do you understand by concurrent programs?

1100

How is choreography different from orchestration?

1135

How can we import the data into a database using sql * loader?

1189

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3665