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 different components you should consider while defining a responsibility in oracle apps?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How can we import the data into a database using sql * loader?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
How can you achieve loose coupling in soa framework?
what are the prerequisites for costing transactions?
Do you know what are user profiles in apps. Any examples you can give?
what is the difference between request group and request security in oracle apps?
List the types of flexfield?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by soa and what are the benefits of using this architecture?
How is choreography different from orchestration?
What do you understand by concurrent programs?
Is soa a part of oracle fusion middleware?
What is a flexfield? List out its types.