NOCYCLE -- 一直累加，不循环
CACHE 10;
示例：CREATE SEQUENCE t_service_sequence INCREMENT BY1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 10;
3)创建触发器（客户端工具添加）
CREATE TRIGGER t_service_triggerBEFORE
insert ON t_service FOR EACH ROW /*对每一行都检测是否触发*/
begin
select t_service_sequence.nextvalinto:New.userid from dual;
end;
示例：
create orreplacetrigger t_service_trigger
before insert on t_service
for eachrow
declare
-- local variables here
begin
select t_service_sequence.nextvalinto:New.idfrom dual;
end t_service_trigger;
4)提交
commit;
5)测试
insert intoTest_Increase(Username) values('test');
6、远程连接
在连接之前设置好监听程序然后使用如下命令：
sqlplus usr/pwd@//host:port/sid
二、SpringJDBC配置
#flow config jdbcfor oracle
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.username=user_test
jdbc.password=user_test123
xml里配置方言：
相关阅读：