Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 77845 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / pnr kiran
DELETE FROM TABLE E
WHERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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
tell my any difficult situtation you solved in your experience in your company?
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.
what are the different transaction clauses in AR?
How can we import the data into a database using sql * loader?
In support project one ticket alloted which steps follows manualy tell me ?
What do you understand by soa and what are the benefits of using this architecture?
How to create a purchase order without a requisition?
Is soa a part of oracle fusion middleware?
How do you register report in oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
Tell me how to find the custom directory in front end?
what are the prerequisites for costing transactions?
Can we create tables in apps schema?
What is the concept of soa governance?
