Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71479 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / xyz
delete from emp where rowid not in(select max(rowid) from
emp group by empno)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you register report in oracle apps?
How can a process be deployed in soa?
Can you differentiate between mediator and osb?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Do you know where we can check the status of po?
What is a value set? List its various types.
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
Tell me how to find the custom directory in front end?
List the types of flexfield?
What are the Standard Reports and Forms in HRMS?
What does appl_top directory contain?
What is oracle soa suite?
Explain oracle apps architecture.
testing tools?
what is the difference between request group and request security in oracle apps?
