Insert returned Rows into diffrent columns
- From: "Oracle" <all_about_oracle@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 04:32:39 +0800
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
Other related posts:
