动态列自动生成 orlce
begin declare CURSOR CURSOR_1 IS select distinct t.课程名 from 课程表 t; begin V_SQL := 'select 1 as tt'; FOR V_PART_QTY IN CURSOR_1 LOOP V_SQL := V_SQL || ',' || 'SUM(DECODE(6,''' || V_PART_QTY.课程名 || ''',
begin declare CURSOR CURSOR_1 IS select distinct t.课程名 from 课程表 t; begin V_SQL := 'select 1 as tt'; FOR V_PART_QTY IN CURSOR_1 LOOP V_SQL := V_SQL || ',' || 'SUM(DECODE(6,''' || V_PART_QTY.课程名 || ''',