Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Answers were Sorted based on User's Feedback



Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / koti

Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .

Is This Answer Correct ?    15 Yes 16 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / madhuapps

delete from t1 tl
where tl.rowid >
( select min(tl2.rowID) from t1 tl2
where tl.col1 = tl2.col1
and tl.col2 = tl2.col2)

Is This Answer Correct ?    25 Yes 31 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / satyan

simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'

Is This Answer Correct ?    4 Yes 11 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / ganesh

delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );

Is This Answer Correct ?    14 Yes 24 No

Post New Answer

More Oracle Apps Technical Interview Questions

Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,


WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  


Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  


How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  


how to initialize applications?

2 Answers  


what is organization id

2 Answers   Wipro,


Form development process?

1 Answers  


What is the difference between BPA AND Contract.

1 Answers   Accenture,


what are the pl/sql tables

1 Answers   IBM,


What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,


what are the profiles

3 Answers   IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)