I am running a stored procedure on ORACLE 10g that truncates and repopulates a table (tbl_A) that contains 2 columns; a list of unique codes and monetary amounts. The number of codes may vary weekly.
I would like to create a second table(tbl_B) that contains a column for each of the names being taken from each of these codes with their monetary amount in that column. Can this be done?
Tbl_A UNIQUE CODES Amount AAA 100.00 BBB 150.00 CCC 200.00 Tbl_B AAA BBB CCC 100.00 150.00 200.00
April 29, 2009 8:34 AM
April 19, 2013 7:23 PM