oracle日期查询Mapper,oracle mapper.xml sql查询

日期字符串转化为时间带时分秒 select * from clamc_operating_data_his and MODIFIED_DATE = ]]> to_date(#{today},'yyyy-mm-dd HH24:mi:ss') and MODIFIED_DATE to_date(#{tomorrow},'yyyy-mm-dd HH24:mi:ss')

模糊查询 select * from clamc_operating_data_mana t t.FILE_DESCRIBE like '%'||#{queryStr}||'%' or FILE_NAME like '%'||#{queryStr}||'%' order by MODIFIED_DATE

根据特定要求排序 select * from clamc_operating_etl_data t order by decode(t.execut_case_code, '1', 1, '2', 2, '3', 3, '0', 4, null, 99) asc

//sql分页查询 Select * from (select ROWNUM rn, t.* from (select * from clamc_operating_data_his)t) where rn between 11 and 20;

foreach select MACHINE_NAME, FILE_NAME from clamc_operating_hs_conf_his t business_date=#{sDate} and MACHINE_NAME in #{matchName}

取最大日期 select * from trustdis_logs t1 t1.creat_date in (select max(creat_date) from trustdis_logs t2

and t2.creat_DATE = ]]> to_date(#{today},'yyyy-mm-dd HH24:mi:ss')

and t2.creat_DATE to_date(#{tomorrow},'yyyy-mm-dd HH24:mi:ss')

and t2.task_name in

#{machineName}

group by task_name)

and t1.task_name in

#{machineName}