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
what are the balancing segments in AR?
Are you familiar with internet architecture of oracle apps 11i?
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
What are the benefits of using soa architecture?
What are do's and dont's of Interface?
What is oracle soa suite?
where to define interorganization transaction charges and what are the different options?
What do you understand by concurrent programs?
How many schemas we have? how many you have used?
How is choreography different from orchestration?
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.
How can you achieve loose coupling in soa framework?
List the types of flexfield?
Can u give the Documentation of Custom.pll in oracle apps
What are the different components you should consider while defining a responsibility in oracle apps?