Converting rows into columns and updating a table Options

[LDP]

Hi,
I have a table A, whose table structure is in the below format.

Table A

ID DESC VALUE
123 A 454
123 B 1111
123 C 111
123 D 222
124 A 123
124 B 1
124 C 111
124 D 44

Now i need to insert the data from this table to another table B, the sturcture of which is as below

Table B

ID A B C D
123 454 1111 111 222
124 123 1 111 44

How do i frame a query to fetch data from table A and insert that into table B? Please help. I don't want to use max and decode combination. as it would return only single row for an ID. I need all the id's to be displayed.

[burleson]

Hi,

Here is how to convert rows to columns:

http://www.dba-oracle.com/t_converting_rows_columns.htm

As for inserting, that should be self-evident! See here for complete details:

http://www.rampant-books.com/book_0902_easy_sql.htm

Good Luck!