Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to search multiple columns?

Re: how to search multiple columns?

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: 26 Jul 2005 13:35:15 -0700
Message-ID: <1122410115.676331.56130@g49g2000cwa.googlegroups.com> 





If you choose to construct the SQL dynamically, make sure you use bind
variables.



This can be done in the OPEN cur_opp FOR "your constructed SQL" USING
... (i think).



If you dont know how many input there are going to be there is a good
trick on the Ask Tom site:-



http://asktom.oracle.com/pls/ask/f?p=4950:8:518665807557106184::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6711305251199
Received on Tue Jul 26 2005 - 15:35:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US