2 Replies Latest reply on Jan 22, 2016 7:59 AM by Rathod Vipul

    ORA-01722: invalid number

    Apex-Thamarai

      I'm having : delimited column like 1:2:3:.i want respective name for the id.

      My query looks like,

      select name from status where id IN (SELECT REPLACE(NEXT_LIST,':',',') FROM status);

      but I got an error

      ORA-01722: invalid number

      please suggest me..

      Thanks