Insert returned Rows into diffrent columns

From: Oracle <all_about_oracle_at_hotpop.com>
Date: Fri, 22 Apr 2005 04:32:39 +0800
Message-ID: <KPEHKOIPDDAJJHPMFNMMOEAKCGAA.all_about_oracle@hotpop.com>

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 Received on Thu Apr 21 2005 - 16:40:16 CDT