pl/sql : using a string variable in a 'WHERE...IN' statement for a numeric column
From: KB <kurt77_at_swbell.net>
Date: 23 Sep 2001 13:55:32 -0700
Message-ID: <5386544a.0109231255.4a8aa57e_at_posting.google.com>
[Quoted] [Quoted] Can I do that? How? Here is the general form for what I am trying to do:
Date: 23 Sep 2001 13:55:32 -0700
Message-ID: <5386544a.0109231255.4a8aa57e_at_posting.google.com>
[Quoted] [Quoted] Can I do that? How? Here is the general form for what I am trying to do:
[Quoted] 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
Received on Sun Sep 23 2001 - 22:55:32 CEST