Write an SQL Query to
Delete Duplicate records from a table using ROWID.
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
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
what is the differences between internal requisition and internal sales order?
List the types of flexfield?
Which oracle apps version you are very confident in?
How to create a purchase order without a requisition?
what is the difference between request group and request security in oracle apps?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
In sequence i want to 11 and 15th values how we will write?
What do you understand by soa?
Can you differentiate between mediator and osb?
What is a flexfield? List out its types.
What do you understand by a set of books?
q)what are the validations in sql*loader
what are the prerequisites for costing transactions?
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