Re: pl/sql : using a string variable in a 'WHERE...IN' statement for a numeric column

"KB" <kurt77_at_swbell.net> wrote in message news:5386544a.0109231255.4a8aa57e_at_posting.google.com...
> Can I do that? How? Here is the general form for what I am trying to
> do:
>
> SELECT C FROM T WHERE T.C IN (c_list)
>
> I'm trying to use this statement with a cursor so that I can fill a
> pl/sql statement with the result set. c_list is a string that is
> created dynamically with TO_CHAR and ||. Maybe there is another way
> to do this that I am overlooking?
>
> Thanks for your help
> Kurt

The answer to this question is version dependent and you don't post a version, so no one will be capable to give the correct answer. Can we have those 3 digits and 2 dots always?

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 23 2001 - 23:17:51 CEST