Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / venki_discussions
delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
where to define interorganization transaction charges and what are the different options?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How do you register report in oracle apps?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is oracle soa suite and what are its different components?
Can we create tables in apps schema?
what are the balancing segments in AR?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
How many schemas we have? how many you have used?
is it possible to run the interface without using oracle apps?
What does appl_top directory contain?
In sequence i want to 11 and 15th values how we will write?
what is the difference between request group and request security in oracle apps?
Is soa a part of oracle fusion middleware?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?