|
|
|
|
|
|
|
|
Re: single row with multiple column into single column - urgent [message #392170 is a reply to message #392169] |
Mon, 16 March 2009 14:00   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Then try a different method COMMA_TO_TABLE and/or str2tab come to mind as search keywords.
The chances of someone else still having a de-supported for years 8i installed somewhere are pretty slim, so you are the the only one who can test the different methods.
Also "wontwork" is not an Oracle error message.
|
|
|
|
Re: single row with multiple column into single column - urgent [message #392172 is a reply to message #392156] |
Mon, 16 March 2009 14:37   |
manimuthuraman
Messages: 6 Registered: July 2006 Location: chennai
|
Junior Member |
|
|
COMMA_TO_TABLE
i got the following code...
while i search...
-- do i concatenate col...coln and shall i pass it as a parameter ??
CREATE OR REPLACE PROCEDURE TEST_SHOW_FROM_LIST (
empno_list IN VARCHAR2)
IS
empnos DBMS_UTILITY.UNCL_ARRAY;
numemps INTEGER;
BEGIN
DBMS_UTILITY.COMMA_TO_TABLE (empno_list, numemps, empnos);
DBMS_OUTPUT.PUT_LINE('');
FOR rownum IN 1 .. numemps
LOOP
DBMS_OUTPUT.PUT_LINE('EMP - '||empnos(rownum));
END LOOP;
END;
/
BEGIN
TEST_SHOW_FROM_LIST('AA,BB,CC,DD,EE');
END;
/
|
|
|
Re: single row with multiple column into single column - urgent [message #392173 is a reply to message #392172] |
Mon, 16 March 2009 14:54   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Wait... The values ARE already in different columns? (Which would have been better visible, if you had formatted your post)
Then why don't you just do a
select col1 from table
union all
select col2 from table
union all
select col3 from table
union all
select col4 from table
union all
select col5 from table
union all
select col6 from table
|
|
|
|
|
|
|