ããOracle åºåï¼Sequenceï¼ä¸»è¦ç¨äºçææµæ°´å·ï¼Oracle EBSç³»ç»ä¸æ¯ç»å¸¸ç¨å°çãä½æ¯ï¼ææ¶éè¦ä¿®æ¹åºååå§å¼ï¼START WITHï¼æ¶ï¼å¥½å¤äººåæè§è®¤ä¸º:Alter Sequence SequenceName Start With Nãäºå®ä¸ï¼å¨Oracle Dbä¸ï¼ä¿®æ¹åºå没æè¿æ ·çè¯æ³ã没æè¿æ ·çè¯æ³æ
åµæä¹åï¼æäºç§æ¹æ³å¯ä»¥å®æ
ãã1.å
å é¤åºåï¼ç¶åéæ°å建ãä¸è¿è¿ä¸æ¯å½åè¦è®²çéç¹ãè¿ä¸ªæ¹æ³æ¯è¾æ¹ä¾¿ã
ãã2.éè¿Increment Byæ¥å®ç°ä¿®æ¹åå§å¼ã
ããä¾å¦ï¼è¥åºåå称æ¯SeqTest2010_Sï¼åå§å¼æ¯13ï¼èç°å¨è¦è®¾ç½®åå§å¼ä¸º1020ï¼Increment Byå¼ä¸º:1007(1020-13)
ãã2.1 æ§è¡:Alter Sequence SeqTest2010_S Increment By 1007;
ãã2.2 æ§è¡:Select SeqTest2010_S.NextVal From Dual;
ãã2.3 æ§è¡:Alter Sequence SeqTest2010_S Increment By 1;
ããä¿®æ¹å®æãç®åå§
温馨提示:内容为网友见解,仅供参考