오라클 폼즈(Forms) - 4 (오라클 기본 SQL 질의)

--select when no data found
BEGIN
  select appraisal_year
  into   now_year_group
  from   NHR_TA_BAROMETER_GROUP
  where  appraisal_year = :control.appraisal_year
     and school_type = :control.school_type
  group by appraisal_year;
  
  exception
    when no_data_found then
         now_year_group := NULL ;
  END;



--insert select
INSERT INTO NHR_TA_BAROMETER_GROUP
              (appraisal_year, SCHOOL_TYPE, barometer_group_id, barometer_group_nm, SEQ_NO, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
               SELECT :control.appraisal_year, school_type, barometer_group_id, barometer_group_nm, seq_no, sysdate, :PARAMETER.USER_ID, :PARAMETER.LOGIN_ID, :PARAMETER.USER_ID, sysdate
             FROM NHR_TA_BAROMETER_GROUP
           WHERE appraisal_year = pre_year AND school_type = :control.school_type;