Re: Insert returned Rows into diffrent columns - II part

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Thu, 21 Apr 2005 22:52:13 +0200
Message-ID: <039701c546b3$ff624dd0$3c02a8c0@JARAWIN>

Hi

you may search Ask Tom on "pivot", e.g. using this link http://asktom.oracle.com/pls/ask/search?p_string=pivot

you'll find a lot of discussion of this thema

Regards

Jaromir
----- 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:58:56 CDT