Interested to Buy Any Domain ? << Click Here >> for more details...
how to eliminate duplictes in column except group and
section?
- 2 Answers
- 6990 Views
- iFlex, TCS, I also Faced
- E-Mail Answers
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 are bind variables?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
In what situation u create the BPA.
what exactly u write in when_new_form_instance
if some data is not transfered where it will get stored
What do you understand by oracle forms?
Explain master-detail relationship with some examples.
What do you understand by lov and how can it be used?
how report can be generated if we have the database designed in oracle 10g?
Name the different triggers associated with oracle forms having a master-detail relationship.
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What do we mean by record group in oracle forms?
hiding item in report how like that properly,thats manually but at runtime i want to do
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Is it possible to execute a dynamic sql from forms?
