1. Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
  2. Suggest New Category

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / rajesh

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


Please Help Members By Posting Answers For Below Questions

q)what are the validations in sql*loader

1736

Do you know where we can check the status of po?

632

where to define interorganization transaction charges and what are the different options?

1947

What are the Standard Reports and Forms in HRMS?

1769

What does appl_top directory contain?

644




is it possible to run the interface without using oracle apps?

1516

What are do's and dont's of Interface?

1903

Explain oracle apps architecture.

760

What is oracle soa suite?

760

how to print multi lay outs,muti currency,muti language in xml publisher

10721

what is pay run id ?

1706

Plz anybody send me Technical specification for AP Interface

2009

In sequence i want to 11 and 15th values how we will write?

1568

what is global tempory table?

6292

Are you familiar with internet architecture of oracle apps 11i?

626