I have a table A with the following data (Table A has 3 columns id, name,
value)
id name value
10 P1 20
10 P2 60
10 P3 12.5
10 P4 26
20 P1 100
20 P2 90
20 P3 15
20 P4 36
30 P1 60
30 P2 50
30 P3 11.5
30 P4 13
.... more rows
I want to insert this data into table B as follows (Table B has 4 columns
id, P1, P2, P3, P4)
id P1 P2 P3 P4
10 20 60 12.5 26
20 100 90 15 36
30 60 50 11.5 13
... more rows
Can you suggest a Sql statement for the insert into table B. Thank you very
much in advance.
Erma
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erma Fernando
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
