Write an SQL Query to
Delete Duplicate records from a table using ROWID.
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
what are the balancing segments in AR?
what is the differences between internal requisition and internal sales order?
Tell me where we find the status of order information?
What are file in oracle.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Is soa a part of oracle fusion middleware?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
How many schemas we have? how many you have used?
Explain what are the tables of auto invoice?
What is sca and how is it useful?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
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
please send me forms, xml pulisher questions,answers
Do you know what are user profiles in apps. Any examples you can give?
what is pay run id ?