Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 77939 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / ajith
DELETE FROM EMP E1
WHERE E1.ROWID>(SELECT MIN(E2.ROWID)
FROM EMP E2
WHERE E1.EMPNO=E2.EMPNO)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is choreography different from orchestration?
Can u give the Documentation of Custom.pll in oracle apps
what is global tempory table?
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
can we use look up type instead of a pofile option?or valueset?is it possible how?
List the various types of value set.
tell me the scenarios of the independent in reports
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What are the different components you should consider while defining a responsibility in oracle apps?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
how do you describe O2C along with tables
How can you achieve loose coupling in soa framework?
do you know is it possible to run the interface without using oracle apps?
what are the balancing segments in AR?
How to create a purchase order without a requisition?
