Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / swati
DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
----------------------------
DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
Do you know what are user profiles in apps. Any examples you can give?
what is pay run id ?
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.
Explain what are the tables of auto invoice?
Is soa a part of oracle fusion middleware?
What are the Standard Reports and Forms in HRMS?
tell my any difficult situtation you solved in your experience in your company?
Explain oracle apps architecture.
Can we create tables in apps schema?
is it possible to run the interface without using oracle apps?
What is count(*) from po_vendors(any table)?
Can you define an erp system?
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
Can u give the Documentation of Custom.pll in oracle apps
In oracle application how do you debug or trace errors?