how to eliminate duplictes in column except group and
section?
Answer Posted / sandeep
the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.
then
delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name having count(*)>1)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between BPA AND Contract What are documents and test cases u followed
What do you understand by lov and how can it be used?
a text item is there what r the different types of triggers associated with it
What do we mean by record group in oracle forms?
What is an oracle report? List its various types.
How can we expand Parameter Form Canvas on Reports 6i?
In what situation u create the BPA.
Explain master-detail relationship with some examples.
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
How to create Drill down report?
what is difference between group above and group left report
Explain the various types of oracle report?
what are the new features introduced in oracle form services in 11g release 2?
What is an SQL FORMS ?