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

Oracle E-Business suite?

2 Answers  


Can function be overload?

4 Answers  


When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,


how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  


What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,






What is procedure?

3 Answers   IBM,


What is Value Set?

2 Answers   Accenture,


What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


What is the difference between base table and multi-org table?

3 Answers   Infosys,


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,


What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,


what is mutating table and mutating error and how to solve that?

3 Answers  


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)