Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71444 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / rajesh
Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);
Regards
Rajesh...
If any queries..then fwd ...baburajeshd@gmail.com
| Is This Answer Correct ? | 91 Yes | 39 No |
Post New Answer View All Answers
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
please send me forms, xml pulisher questions,answers
Can you define an erp system?
where to define interorganization transaction charges and what are the different options?
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
What are the different components of soa suite?
q)what are the validations in sql*loader
Is soa a part of oracle fusion middleware?
What do you understand by a set of books?
Explain oracle apps architecture.
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
What is sca and how is it useful?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How can a process be deployed in soa?
is it possible to run the interface without using oracle apps?
