再插入数据的时候,id直接填写 hibernate_sequence.nextval 方便省事
demo:
insert into fht_pointexchangerate (ID, CITYID, CITYNAME, COMPANYMARK, CREATETIME, DEL)
values (hibernate_sequence.nextval, '36', '安庆市', '1', '02-APR-18 11.19.23.507000 AM', 0);
decode 函数用法
decode(lowerLevel,0,orderOwnerPoint,1,0)
sql测试(别人的代码,拷贝过来,下次方便自己使用此函数)
select empno,decode(empno,7369,'smith',7499,'allen',7521,'ward',7566,'jones','unknow') as name from emp where rownum<=10
输出结果
7369 smith
7499 allen
7521 ward
7566 jones
7654 unknow
7698 unknow
7782 unknow
7788 unknow
7839 unknow
7844 unknow
这样就行了