dbms_utility.comma_to_table (merged) [message #402638] |
Mon, 11 May 2009 13:24 |
lamnguyen14
Messages: 119 Registered: March 2007 Location: Virginia
|
Senior Member |
|
|
Good Afternoon.
Would you please to help me with this? I have a script:
DECLARE
v_table dbms_utility.uncl_array;
v_len number;
BEGIN
dbms_utility.comma_to_table('"1","2","3"', v_len, v_table);
for i in 1..v_len
loop
dbms_output.put_line(v_table(i));
end loop;
END;
my output is:
"1"
"2"
"3"
Would you please to show me how to get rid of the double quote " " in my output? I would appreciate that.
Thanks much
LN
|
|
|
|
|
Re: dbms_utility.comma_to_table (merged) [message #402783 is a reply to message #402644] |
Tue, 12 May 2009 08:05 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Yiou have to wrap your values in double quotes if you want to use comma_to_table - otherwise it tries to validate each item as a valid oracle object name.
In addition to Michel's suggestions of REPLACE and TRIM, you could use SUBSTR, or REGEXP_REPLACE, or, if you really want to go over the top, DBMS_UTILITY.CANONICALIZE
|
|
|