Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71446 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 are the Standard Reports and Forms in HRMS?
where to define interorganization transaction charges and what are the different options?
can we get profile values in report without using user exists is it possible how?
What does appl_top directory contain?
What do you understand by soa?
How can a process be deployed in soa?
How to create a purchase order without a requisition?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What is sca and how is it useful?
do you know is it possible to run the interface without using oracle apps?
What is a value set? List its various types.
What are the different components you should consider while defining a responsibility in oracle apps?
Can we create tables in apps schema?
How can we import the data into a database using sql * loader?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
