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
Explain the different levels at which oracle form services interact.
difference between global n context sensitive segments?
What is an SQL FORMS ?
hiding item in report how like that properly,thats manually but at runtime i want to do
what is difference between group above and group left report
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What is an oracle report? List its various types.
What do we mean by record group in oracle forms?
Explain the various types of oracle report?
did u p prepared complex report
What is the difference between flex mode and confined mode?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
Explain how one can iterate through items and records in a specified block?
Is it possible to have multiple layouts in a report?