how to eliminate duplictes in column except group and
section?
Answer Posted / jagan
delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
can you convert or reverse engineer a fmx back to a fmb file?
what is tripstop report?
Name the different triggers supported by oracle reports and their firing order.
Explain master-detail relationship with some examples.
what is the difference between call_form, new_form and open_form?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is an oracle report? List its various types.
In what sequence do triggers get fired by oracle forms?
What is an oracle report?
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
i am writing a query select EmpNo from Emp how can i call in after parameter form
what are bind variables?
a text item is there what r the different types of triggers associated with it
What is a user exit program in oracle reports?