Re: Insert returned Rows into diffrent columns - II part
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <all_about_oracle@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 22:52:13 +0200
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@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:
- » Re: Insert returned Rows into diffrent columns - II part
