Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oracle pre-query ampersand
Hello,
how can I achieve an "ampersand"-query
in a pre-query-trigger?
What I mean with "ampersand"-query:
- Key "Enter-Query"
What I do ** not need **:
Help on using pre-query with '#'.
I cannot use '#', because I have to specify a condition over two fields
which is not independent (i.e. one could say:
(fiel1,field2) in (select f1,f2 from Another_Table),
which is not the same as :
(in field1) : # in (select f1 from Another_Table) ,
(in field2) : # in (select f2 from Another_Table)
Received on Tue Sep 11 2001 - 09:09:45 CDT