sql

update GRAS_DEPT_SERVICER
         set
         SERVICER_NO=#{servicerNo,jdbcType=VARCHAR},
         UPDATED_USER = #{updatedUser,jdbcType=VARCHAR},
         UPDATED_DATE =sysdate
         where
         DEPT_NO =#{deptNo,jdbcType=VARCHAR}
         and  IS_VALID='Y'
         
         
         
         
         
          select  gbe.bank_code,di.dept_name,si.emp_no,si.emp_name,bi.branch_code,bi.branch_name,gbe.PK_SERIAL
     from GRAS_BANK_EMP gbe,
     staff_info si,
     department_info di,
      branch_info bi
     where
        gbe.emp_no=si.emp_no
        and si.dept_no=di.dept_no
       and di.branch_code=bi.branch_code 
       and gbe.END_DATE is null
       
       
       
       select * from( 
select rownum as rowno,gbe.bank_code,di.dept_name, si.emp_no,si.emp_name,bi.branch_code,bi.branch_name,gbe.PK_SERIAL
 from GRAS_BANK_EMP 
 gbe, staff_info si,
 department_info di,
 branch_info bi 
 where gbe.emp_no=si.emp_no and si.dept_no=di.dept_no and di.branch_code=bi.branch_code and gbe.END_DATE is null and bi.branch_code=? and rownum <= ?*? ) table_alias where table_alias.rowno>(?-1)*?