9 Replies Latest reply on Jun 19, 2013 3:59 AM by Maddy

    comma separated data into IN clause in oracle report query

    Maddy

      i have a field on form as order number it takes more than one value as 1,2,3

      now i want to fetch data in report query for where order no in 1,2 and 3...

      but field takes value as 1,2,3...

      how can i separte the comma from value and how can i pass value in IN clause...or

      how can i get all records with order no 1,2,3...

      please suggest how can i achieve the same....