DA Morgan wrote:
> Christoph Seidel wrote:
>
>> Christoph Seidel wrote:
>>> DA Morgan wrote:
>>>> Kenneth and Karsten's responses are good general methods. If your
>>>> comma delimited values are no more than 30 characters,
>>>> DBMS_UTILITY.COMMA_TO_TABLE is far more efficient.
>>>
>>> well, really great tip! thanx alot!
>>
>> oops, not a great tip :) does not work with numbers, i think with
>> "list of names" the docs mean list of object names in the data
>> dictionary!?
>
> Works with numbers ... you just need to use REPLACE to replace the
> commas with "," (double quote comma double quote) and concatenate
> double quotes at the beginning and end of the string.
Hu, how can one find this out since the package is obfuscated (at least in
my ora 9i)?!
Received on Sat Feb 22 2003 - 13:52:47 CST
