How to convert a string list to number list
853934Apr 8 2011 — edited Apr 11 2011Hi
I have a table1 that codeid is a number(2)
and other table2 that obtain the codeidlist in a varchar2(50) where I save the codeid that I selected from table 1, I can be one o more : 1,2,4,5 etc.
I wanna make this but It gives an error: Invalid Number
Select * from tabla1
where codeid i not in (select codelidlist
from table2
where cliente='Oscar')
how can I solve that?