title: Multiple input value for single field - PLSQL
body: <p>I have created a query in PLSQL to search customer records from the tables. But still has some limitations. In the <strong>&amp;CUSTOMER_ID</strong> Search field If I Put <strong>IN%</strong> OR <strong>DL100056</strong>* It will search All the details which start with IN or giving the exact DL details as output. I want to search multiple values like in the customer Id field I wanna search DL100056,DL1000365,DL1000652 likewise. But my current query not giving multiple outputs.</p>
  <pre><code>
  SELECT 
  DISTINCT CUSINFO.CUSTOMER_ID AS DEALER_CODE,
  CUSINFO.name AS DEALER_NAME,
  CUSINFO.CORPORATE_FORM AS FORM_OF_BUSINESS,
  C.corporate_form_desc AS FORM_OF_BUSINESS_DESCRIPTION,
  ifsapp.Customer_Info_Address_Api.Get_Address1(CUSINFO.customer_id,1) &quot;ADDRESS 1&quot;,
  ifsapp.Customer_Info_Address_Api.Get_Address2(CUSINFO.customer_id,1) &quot;ADDRESS 2&quot;,
  CREDTIN.credit_limit AS CREDIT_LIMIT,
  CREDTIN.allowed_due_amount AS ALLOWED_DUE_AMOUNT,
  CREDTIN.allowed_due_days AS ALLOWED_DUE_DAYS,
  ORDERC.salesman_code AS SALESMAN_CODE,
  BDA.name AS SALESMAN_NAME,
  ORDERC.discount AS DISCOUNT,
  (select LISTAGG(c.value,' / ') within group (order by c.value) from ifsapp.COMM_METHOD c 
   where c.method_id_db='PHONE' and c.identity=CUSINFO.customer_id ) &quot;Phone&quot;,
  (select LISTAGG(c.value,' / ') within group (order by c.value) from ifsapp.COMM_METHOD c 
   where c.method_id_db='MOBILE' and c.identity=CUSINFO.customer_id) &quot;Mobile&quot;,
   (select LISTAGG(c.value,' / ') within group (order by c.value) from ifsapp.COMM_METHOD c 
  where c.method_id_db='FAX' and c.identity=CUSINFO.customer_id) &quot;Fax&quot;,
  CUSINFO.identifier_reference as IDENTIFIER_REFERENCE
  
  
  FROM
  ifsapp.CUSTOMER_INFO CUSINFO
  LEFT JOIN
  ifsapp.CUSTOMER_INFO_ADDRESS CUSADD ON CUSINFO.customer_id=CUSADD.customer_id
  LEFT JOIN
  ifsapp.CUSTOMER_INFO_CONTACT CUSCONT ON CUSINFO.customer_id=CUSCONT.customer_id
  LEFT JOIN
  ifsapp.CUSTOMER_CREDIT_INFO_CUST CREDTIN ON CUSINFO.customer_id=CREDTIN.identity
  LEFT JOIN
  ifsapp.CUST_ORD_CUSTOMER_ENT ORDERC ON CUSINFO.customer_id=ORDERC.customer_id
  LEFT JOIN
  ifsapp.Comm_Method COMM ON CUSINFO.customer_id=COMM.customer_id
  LEFT JOIN
  ifsapp.CORPORATE_FORM C ON CUSINFO.corporate_form=C.CORPORATE_FORM
  LEFT JOIN
  ifsapp.SALES_PART_SALESMAN_LOV BDA ON ORDERC.salesman_code=BDA.salesman_code
  
  WHERE CUSINFO.CUSTOMER_ID LIKE '&amp;CUSTOMER_ID'
  </code></pre>