On Sat, 10 Nov 2001 10:08:19 GMT, Radu Lascae
<r.nospam.lascae_at_wanadoo.nl> a écrit:
>Yes, you can. Not in SQL though - as you can't determine in advance the
>number of Look_Id's. You'll need a function, using a cursor to loop through
>the records and concatenate the results. Then use the function in an SQL
>statement. This what you want?
>
Beware of the max length authorized, though. For a VarChar2, it's 4000 chars
when passing through sqlplus, ado ...
(between stored procedure and functions it's 32k)
--
Damien
Received on Sat Nov 10 2001 - 05:02:51 CST
