日期:2014-05-17 浏览次数:20974 次
AID BID Bname AKey AValue
F320 4C61 ZS 1 P1
F320 9FB1 LS 2 P2
F320 4C61 ZS 2 P2
F320 4C61 ZS 3 P3
AID BID Bname AKey AKey AKey AValue AValue AValue
F320 4C61 ZS 1 2 3 P1 P2 P3
F320 9FB1 LS 0 2 0 0 P2 0
create or replace procedure row_to_col(tabname in varchar2,
group_col in varchar2,
column_col in varchar2,
value_col in varchar2,
Aggregate_func in varchar2 default 'max',
&n