idea开发-使用oracle数据库-mapper文件中-常用语句

两个字段拼接：

(trim(f4101.imdsc2)||(case when trim(f4101.imsrtx)='@'then''else to_char(trim(f4101.imsrtx))end))

 

to_char(sysdate,'yyyy-MM-ddHH24:mi:ss')

 

to_char(sysdate,'yyyy-mm-dd')

 

to_char(sysdate,'hh24miss')

 

ROW_NUMBER()OVER(PARTITION BY work_code ORDER BY work_code)

 

(CASE WHENlength(trim(WORKCODE)) > 8 THEN substr(trim(WORKCODE), 2, 8) ELSEtrim(WORKCODE) END)

lpad(to_char(u.ABAN8),8,'0')

 

lpad(to_char(f0101.aban8),8,'0')

lpad(trim(f01.aban8),8,'0')

 

to_char(sysdate,'yyyy-MM-dd')

to_char(sysdate,'YYYY-MM-DDHH24:MI:SS')