我正在创建一个select语句,它使用dual表生成一个and和3列以及end_date、table_name和kpi。SELECT TRUNC (SYSDATE, 'iw') - LEVEL AS end_date, 'MyTable' AS table_name , 'kpi_1' as kpi
FROM DUAL
DATE DIVISION KPI ACTUAL01-07-2014 HYDROWHEN KPI IS 1, THEN ACTUAL.WHEN KPI IS 2, THEN DIVIDE KPI 2/KPI 1 OF ACTUAL. 200/100 =2
WHEN KPI IS 3, THEN DIVIDE KPI 4/