SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

list of values minus select query

user12152459Nov 2 2009 — edited Nov 2 2009

Hi

I have list of fixed values say (2,3,5,7,11,13, .. ...97). I want to minus this list withe some query. how can I do that in oracle 9i sql.
ex:

select (abovelist)
minus
select value from numbers;

I don't want to create the table with above list and minus it.

Regards,
Venkat

Edited by: user12152459 on Nov 2, 2009 10:08 PM

This post has been answered by Frank Kulash on Nov 2 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2009

Added on Nov 2 2009

#9i, #sql

3 comments

1,277 views