Re: Insert returned Rows into diffrent columns

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <all_about_oracle@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Apr 2005 22:46:23 +0200

Hi,

the solution below event doesn't need the table A: 

insert into b
values('pk',1,2,3,4,5,6,7,8,9,10);

Alternatively you may search ask tom on "pivot"

----- Original Message ----- 
From: "Oracle" <all_about_oracle@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, April 21, 2005 10:32 PM
Subject: Insert returned Rows into diffrent columns


Hi,

I have table always with 10 records. I want to insert these records into
another table but each record will goes to column PK, A, B, C, D, E, F, G,
H, I and J.

Select * from table a;

col1
-----
1
2
3
4
5
6
7
8
9
10

10 rows returned

I want to insert into table B

PK  A  B C  D  E  F G  H  I   J
---   -- -- -- --  -- -- -- -- --  ---
A1   1  2 3  4   5  6   7  8  9   10

1 row returned


Can Oracle do this?


Thanks




--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l

Other related posts: