一条SQL语句就行了!
select name,
decode(km,'math',score,0) math,
decode(km,'Chinese',score,0) Chinese,
decode(km,'English',score,0) English,
......
from table
select name,
decode(km,'math',score,0) math,
decode(km,'Chinese',score,0) Chinese,
decode(km,'English',score,0) English,
......
from table
我也没用存储过程