Home » SQL & PL/SQL » SQL & PL/SQL » reak the columns values
reak the columns values [message #748] Fri, 01 March 2002 08:37 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 column values, 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: reak the columns values [message #757 is a reply to message #748] Fri, 01 March 2002 15:41 Go to previous message
raji
Messages: 30
Registered: February 2002
Member
Try this
create table a1 as select test1||','||test2 a_col from ravi;
this will create a table a1 with a column a_col.
Previous Topic: breaking column values
Next Topic: Differ in Join And Union
Goto Forum:
  


Current Time: Thu Mar 28 04:37:12 CDT 2024