sql中table用法

 for c in (select column_value from table(f_split(V_FileID, ','))) loop
      --若没有填写资格开始结束时间，则填入
      select count(*)
        into numDataCount
        from ly_zg_jzfbt z
       where file_id = c.column_value
         and z.pt_valid_stime is null;
      if numDataCount > 0 then
        update ly_zg_jzfbt z
           set z.pt_valid_stime     = trunc(sysdate),
               z.pt_valid_etime     = add_months(trunc(sysdate), 12) - 1,
               z.fanaly_valid_etime = add_months(trunc(sysdate), 12) - 1
         where z.file_id = c.column_value;
        commit;
      end if;
    
      select l.CONTROL_ID
        into numControl
        from ly_zg_jzfbt l
       where file_id = c.column_value;
      varERRMSG := PK_JJZLFBTINFO.F_CheckStandard(c.column_value,
                                                  to_char(numControl));
      if varERRMSG is not null then
        raise_application_error('-20001', varERRMSG);
      end if;
      PK_FAMILYHOUSE.P_GetFamilyHouseInfoData(
                                              numControl,
                                              c.column_value,
                                              p_temp);
      if varERRMSG is not null then
        raise_application_error('-20001', varERRMSG);
      end if;
      PK_FAMILYINFO.P_GetFamilyInfo(
                                    c.column_value,
                                    p_temp);
      if varERRMSG is not null then
        raise_application_error('-20001', varERRMSG);
      end if;
    
      select l.is_over_certificate
        into doCeritify
        from ly_zg_jzfbt l
       where file_id = c.column_value;
    
      if doCeritify is null or doCeritify = 1 then
        update ly_zg_jzfbt l
           set l.do_certificate_time = sysdate, l.is_over_certificate = 0
         where file_id = c.column_value;
        commit;
      end if;
      --将out出的内容与file_id拼接在一起
      varIncomeAvg_All         := varIncomeAvg_All || c.column_value || ':' ||
                                  numIncomeAvg || ',';
      varIdentifiedArea_All    := varIdentifiedArea_All || c.column_value || ':' ||
                                  numIdentifiedArea || ',';
      varPerIdentifiedArea_All := varPerIdentifiedArea_All ||
                                  c.column_value || ':' ||
                                  numPerIdentifiedArea || ',';
    end loop;