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