Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating query based on results of a query...
"CloudsŪ" <DOCloudsNOT_at_hardwareSPAM-spot.com> wrote in message news:<40e40d98$0$48933$e4fe514c_at_news.xs4all.nl>...
> I'd like to do something like this:
>
> select * from table1
> where table1.value (select operator from table2) (select value from table2)
>
> So the problem is getting an operator from table2 and use it in the query on
> table1.
> Table2.operator is in the form of = , > , != etc...
This is not possible in plain SQL (Dynamic SQL and procedural languages don't count). SQL is presize: you just specify what you want. Your problem statement, however, contains an ambiguity: operators and values from table2 could be either be conjuncted, or disjuncted (although, in earlier message you mentioned that you want conjunction).
You can look into expression filter developers guide. Received on Thu Jul 01 2004 - 16:40:04 CDT