Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / veera
delete from tablename where rowid not in(select min(rowid)
from table name group by duplicate record col)
| Is This Answer Correct ? | 37 Yes | 21 No |
Post New Answer View All Answers
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What do you understand by soa?
is it possible to run the interface without using oracle apps?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Tell me how to find the custom directory in front end?
What is count(*) from po_vendors(any table)?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
tell me the scenarios of the independent in reports
How to create a purchase order without a requisition?
What do you understand by concurrent programs?
What are the Standard Reports and Forms in HRMS?
What does appl_top directory contain?
What do you understand by soa and what are the benefits of using this architecture?
What are the different components of soa suite?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?