Oracle
引影
这个作者很懒,什么都没留下…
展开
-
数据库SQE刷新
SELECT costmgmt.SEQ_ID.nextval FROM dual;DECLAREvnumber NUMBER;nnumber NUMBER;BEGIN SELECT ( (SELECT max(pn.ID ) FROM COSTMGMT.PN pn) - costmgmt.SEQ_ID.nextval ) INTO vnumber FROM dual; IF vnumber > 0 THEN EXECUTE.原创 2020-11-20 15:55:18 · 208 阅读 · 0 评论 -
原生SQL查询字段类型转换异常处理
//NVARCHAR转换异常public class MyOracleDialect extends Oracle10gDialect { public MyOracleDialect() { super(); registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName...原创 2019-03-07 11:19:39 · 942 阅读 · 0 评论