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

Home -> Community -> Usenet -> c.d.o.tools -> input parameters

input parameters

From: Andy <andy.konopka_at_camtronics.com>
Date: Tue, 3 Apr 2001 15:15:14 -0500
Message-ID: <0bqy6.6230$7e6.2090560@homer.alpha.net>

I was wondering if I could perform the following SQL query but if someone leaves one or more of the criteria blank eliminate it from my search by -- so if someone queries by state, leave the customer name and city out of the search or if some leaves the city blank query only by the name and the state given to the query -- here is the query SELECT A.NAME,B.CUSTOMER_ID, B.ADDRESS_ID,                B.ADDRESS, B.PARSED_CITY, B.PARSED_STATE   FROM CUSTOMER_INFO A,
              CUSTOMER_INFO_ADDRESS B
 WHERE A.NAME LIKE '&NAME'

         OR B.PARSED_CITY = '&CITY'
         OR B.PARSED_STATE ='&STATE'
      AND B.CUSTOMER_ID = A.CUSTOMER_ID;
Received on Tue Apr 03 2001 - 15:15:14 CDT

Original text of this message

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