CREATE SEQUENCE [schema_name.]{sequence_name}-- schema_name为将存储序列的模式名,sequence_name 为自定义名称;START WITH n-- n 为序列的初始值,默认为1;INCREMENT BY n-- n 为序列步长(序列增加的幅度),默认为1,如果是负则按此步长递减;[MINVALUE n | NOMINVALUE ]-- 如果序列递减,定义序列生成器...
算出当前值，和你要修改的值的差（正负都可以）假设为 100 alter sequence SEQ_name increment by 100 nocache;select SEQ_name.nextval from dual;alter sequence SEQ_name increment by 1 cache 20;
sequence_name 为自定义名称;STARTWITHn-- n 为序列的初始值,默认为1;INCREMENTBYn-- n 为序列步长(序列增加的幅度),默认为1,如果是负则按此步长递减;[MINVALUEn|NOMINVALUE]-- 如果序列递减,定义序列生成器能产生的最小值,默认为1[MAXVALUEn|NOMAXVALUE]-- 定义序列生成器能产生的最大值,默认无限制(1...
① select last_number from user_sequences where sequence_name='SEQ_ON_USER'; ② select SEQ_ON_USER.nextval from sys.dual; 定义好sequence后,你就可以用currVal,nextVal取得值。 CurrVal:返回sequence的当前值 NextVal:增加sequence的值,然后返回 增加后sequence值 得到值语句如下: SELECT Sequence名称.CurrVal...
I am trying to update last number of sequence in database oracle using textbox on C#. When I tried to execute my program, I have got the error message{"ORA-01036: illegal variable name/number"}I am trying to rectify this problem, but I did not find how to fix it. I...
2、查看已有sequence: select * from user_sequences; select * from user_sequences; 3、删除指定sequence: DROP SEQUENCE SEQ_ON_USER; DROP SEQUENCE SEQ_ON_USER; 4、查看指定sequence的当前值: 两种方式: select last_number from user_sequences wheresequence_name='SEQ_ON_USER'; select last_number ...
SQL> select * from dba_sequences where sequence_name='MY_SEQUENCE_TEST'; 1. 1. SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER 1. --- --- --- --- --- - - --- --- 1. TEST MY_SEQUENCE_TEST 1 999999999 1 N N 0 1 1. 1. SQL>...
查看序列号,last_number是当前值的代码如下。SQL>select * from user_sequences; 5.视图查看视图的名称的代码如下。SQL>select view_name from user_views; 查看创建视图的select语句如下。SQL>set view_name,text_length from user_views; SQL>set long 2000; %说明:可以根据视图的text_length的值设定set long...
SEQUENCE_NUMBER , ACTION , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY ) VALUES ( 1234, -1, 10, NULL , '11-12-2009', '20-12-2009', 50,1, NULL , SYSDATE, -1 , SYSDATE, -1 ); INSERT INTO PON_AUC_PRICE_ELEMENTS_INT ...
CACHE_SIZE NOT NULL NUMBER LAST_NUMBER NOT NULL NUMBER 查看刚才创建的序列seq_tmp 的值: SQL> select * from user_sequences where sequence_name='SEQ_TMP'; SEQUENCE_N MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER --- --- --- --- - - --- --- SEQ_TMP 1 1.0000E+2...