breaking column values [message #37836] |
Fri, 01 March 2002 08:39 |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
Hi,
I have a table called ravi(TEST1 varchar2(200),TEST2 varchar2(200)
I will have column TEST1 values(a,b,c,d,e,...etc)
column TEST2 values(1,2,3,4,5,...etc)
I wanted to break the columns, so that resultant table will contain values like
a,1
b,2
c,3
etc..
Here the thing is I will receive equal number of n' values for TEST1,TEST2 columns.
Thanks for your help
Ravi
|
|
|
Re: breaking column values [message #37839 is a reply to message #37836] |
Fri, 01 March 2002 12:31 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I'm not sure that I fully understand the question, but try this...
select test1||','||test2 Test1_and_2 from ravi;
select test1||','||test2 Test1_and_2 from ravi
where test1 is not null
and test2 is not null;
|
|
|