Re: Insert returned Rows into diffrent columns

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Thu, 21 Apr 2005 22:46:23 +0200
Message-ID: <037d01c546b3$2ef69750$3c02a8c0@JARAWIN>

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_at_hotpop.com> To: <oracle-l_at_freelists.org> 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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 21 2005 - 16:53:10 CDT