Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / parthasarathi
delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
please send me forms, xml pulisher questions,answers
What is sca and how is it useful?
What is the concept of soa governance?
What do you understand by soa?
Do you know where we can check the status of po?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
where to define interorganization transaction charges and what are the different options?
How do you register report in oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
Can we create tables in apps schema?
what is the differences between internal requisition and internal sales order?
In support project one ticket alloted which steps follows manualy tell me ?
Can you differentiate between mediator and osb?
List the various types of value set.
How many schemas we have? how many you have used?