sql
1.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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)*?
select count(1) from branch_info bi where bi.branch_level='03' and bi.branch_code='864110' and bi.parent_branch='8641'