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
- 77599 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / koti
delete from emk tl
where tl.rowid >
( select min(tl2.rowID) from emk tl2
where tl.empno = tl2.empno
and tl.ename = tl2.ename)
Madhuapps,is alsow right...
| Is This Answer Correct ? | 16 Yes | 10 No |
Post New Answer View All Answers
What is instead of trigger in where we will use?
can we get profile values in report without using user exists is it possible how?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What are do's and dont's of Interface?
Can we create tables in apps schema?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
List the various types of value set.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
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
What do you understand by concurrent programs?
What are the different components of soa suite?
Is soa a part of oracle fusion middleware?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Can you explain the difference between architecture followed in 10g & 11g?
In oracle application how do you debug or trace errors?
