FAQ
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: cecfernan_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 4 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 22, '01 at 7:15p
activeMar 22, '01 at 9:47p
posts4
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase