4 Replies Latest reply: Jul 28, 2014 7:31 AM by Papai RSS

    How To Use IN Operator In Filter

    Papai

      Dear Gurus,

               I have a File To RT interface. As a filter condition I have used the below(like) code:-

      ARG.CENTRE_CODE_COLUMN = IN (select center_code from table_center_codes; )

      but it is throwing ORA-00936: missing expression error.

      What to do? Please advise.

       

      At least please let me know how shall I implement my requirement? My requirement is:-

       

      Suppose Src File needs to filtered based on its center code value  AA,BB,CC,DD,EE....etc.

      i.e  ARG.CENTRE_CODE_COLUMN='AA'  OR ARG.CENTRE_CODE_COLUMN='BB'  OR ARG.CENTRE_CODE_COLUMN='CC'

      Instead of using this long code I have stored these AA,BB...LookupValue (Filter Codes value)  in a separate table table_center_codes .

      and use the code ARG.CENTRE_CODE_COLUMN = IN (select center_code from table_center_codes; ) I.E tried to get the Filter condition value

      dynamically from the table_center_codes table.

      But it fails.

      Thanks

      Papai

      NB:- PLEASE LET ME KNOW YOU HAVE ANY CONFUSION ABOUT THE REQUIREMENT.