摘要:
摘录:https://blog.csdn.net/qq_35661171/article/details/78839642 System.currentTimeMillis() currentTimeMillis方法 public static long currentTimeMillis() 该方 阅读全文
摘要:
--importFlag字段改为string类型alter table Ghreqcoverage modify (importFlag varchar2(2));-- 因为importFlag字段中有值 直接修改报错:column to be modified must be empty to c 阅读全文
摘要:
mybatis xml DAO int deUndwrtList(@Param("certiNos")List<String> certiNos); <update id="deUndwrtList" parameterType="java.util.List"> Update PrpTmain m 阅读全文
摘要:
--0点显示 select b.vcieffectivedate as a ,to_char(b.vcieffectivedate,'yyyy-mm-dd hh24:mi:ss') as b from ghresbase b where b.vcieffectivedate is not null; 阅读全文
摘要:
--查询某字段不重复数据并取出最新的select * from (select m.proposalno,m.operatedate,m.underwriteflag ,row_number() over(partition by underwriteflag order by operatedat 阅读全文