Re: how can i find the result?

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Fri, 15 Jun 2001 14:23:09 GMT
Message-ID: <MPG.1593d759dcd8692298979e@news.randori.com>

Hey;

I know I'm on the right track - just can't get all the way there & unfortunately ran out of time. Perhaps someone a little smarter than I am can take you the rest of the way...

To find all the numbers that are currently in your list (convoluted method, but step 1):

SQL> list
  1 select no
  2 from find_number
  3 where no in

  4     ( select rownum rnum
  5             from all_objects
  6             where rownum <= (
  7                     select max(no)
  8                     from find_number)

  9* )
SQL> /         NO

---

         1
         2
         3
         5
         7

Logically, setting 'not in' should find the numbers that *aren't* in your list; however, when I do that, I get a 'no rows selected'

SQL> list
  1 select no
  2 from find_number
  3 where no not in

  4     ( select rownum rnum
  5             from all_objects
  6             where rownum <= (
  7                     select max(no)
  8                     from find_number)

  9* )
SQL> / no rows selected

Hopefully, that'll point you in the right direction...

Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net

Received on Fri Jun 15 2001 - 09:23:09 CDT