查询当前所有序列 :select * from user_sequences;
查询指定名字序列:
select * from user_sequences where sequence_name like ‘%T_SELL_BRAND%’;
select * from user_sequences where sequence_name=‘SEQ_T_SELL_BRAND’;
查询指定序列下一个值:
select 序列名.nextval from dual ;
查询指定序列当前值:
select 序列名.currval from dual;
如果序列设置了缓存,则一次会获取多个序列值,多个客户端同时操作会导致冲突
Java中配置datasource时11g和12c有区别
11g:jdbc:oracle:thin:@192.168.55.29:1521:qmtdb
12c:jdbc:oracle:thin:@//192.168.55.29:1521/qmtdb