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
In hierarchical structure of a database? we have write query from where we should start?
what are the different transaction clauses in AR?
Can u give the Documentation of Custom.pll in oracle apps
Tell me how to find the custom directory in front end?
tell me the scenarios of the independent in reports
What are file in oracle.
q)what are the validations in sql*loader
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
How can a process be deployed in soa?
what are the balancing segments in AR?
Are you familiar with internet architecture of oracle apps 11i?
please send me forms, xml pulisher questions,answers
where to define interorganization transaction charges and what are the different options?
List the types of flexfield?
What is the concept of soa governance?