Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Insert returned Rows into diffrent columns - II part
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
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