Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / parthasarathi
delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the balancing segments in AR?
List the various types of value set.
Do you know what are user profiles in apps. Any examples you can give?
How to create a purchase order without a requisition?
What are the Standard Reports and Forms in HRMS?
In oracle application how do you debug or trace errors?
What are the different components of soa suite?
Plz anybody send me Technical specification for AP Interface
What is the concept of soa governance?
What is oracle soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
do you know is it possible to run the interface without using oracle apps?
What is oracle soa suite and what are its different components?
Can you explain the difference between architecture followed in 10g & 11g?
Explain what are the tables of auto invoice?