In my table "temp" one column contain 1 to 10 range of values in between some numbers are missing. like belowTEMPcolumn112475so in this table i want search missing number from 1 to 10.so output should be 3689.how to get this o/p?

Interview Candidate
May 31st, 2007
3
1796

Showing Answers 1 - 3 of 3 Answers

gaurav_gupta81

Jun 7th, 2007

Its simple, just use such query

print ( select from (Loop var 1 to (count (select * from temp1)) where var NOT IN (select * from temp1))))

means just print the number from the loop where that number is not in the result provide by the select statement for that column.

Hope you get my point

Amit

Jun 14th, 2007

If I have Emp Table and id column
1
2
4
5
7
SELECT 10-id FROM Emp WHERE id in (SELECT id FROM Emp WHERE id <> 5)

chakraborty_sarkar
Profile Answers by chakraborty_sarkar

Jul 10th, 2007

SELECT LEV FROM (SELECT LEVEL LEV FROM dual CONNECT BY LEVEL < 10) WHERE LEV NOT IN (SELECT COLUMN1 FROM TEMP);