Home » SQL & PL/SQL » SQL & PL/SQL » breaking column values
breaking column values [message #37836] Fri, 01 March 2002 08:39 Go to next message
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

Report message to a moderator

Re: breaking column values [message #37839 is a reply to message #37836] Fri, 01 March 2002 12:31 Go to previous message
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;

Report message to a moderator

Previous Topic: how do i get the total differnce of 2 dates through sql statement
Next Topic: reak the columns values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 13:41:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.