摘要： create or replace procedure typeHinDascursor typeall is select id,name from tbl_en_type; --查询出来所有分类cursor hournum is select EN_VAL_ORG,EN_VAL_STD,EN_COST,UNIT_ID,SUPER_ID,INDS_ID,EN_TYPE_ID,STAND_COE from tbl_unit_en_type_hour where to_date(sysdate-1,'dd-mon-yyyy') = to_date(en_date,'dd- 阅读全文