SQL & PL/SQL

A table say T1 contains column like Emp_id,Code.
and there are several Code like C1,C2,C3.

Another table say T2 contains column like
Emp_id,C1,C2,C3.Here the value of the code field of the
T1 table is now column of the T2 table.And the amount of
each code of T1 table is equal to column value of T2
table.

Now I want to retrieve data from T2 table like
C1 200
C2 300
C3 140

I cannot retrieve data like this using all_tab_columns.
I can only getting the column_name but cannot its value.
PLEASE HELP ME...

Edited by: user630863 on Apr 8, 2009 11:37 AM