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

Answer Posted / samad

delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)

cheers
samad

Is This Answer Correct ?    21 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the balancing segments in AR?

1653


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

629


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

3078


What are the benefits of using soa architecture?

709


What are do's and dont's of Interface?

1905






What is oracle soa suite?

764


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

1952


What do you understand by concurrent programs?

619


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

1614


How is choreography different from orchestration?

652


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2465


How can you achieve loose coupling in soa framework?

722


List the types of flexfield?

605


Can u give the Documentation of Custom.pll in oracle apps

2995


What are the different components you should consider while defining a responsibility in oracle apps?

642