Create Sequence MySequence Start With 1 Increment By 1 Nocycle Nocache;說明：序列MySequence從1開始遞增，每次加1，一直累加不循環。若把Nocache改為Cache,那麼Oralce會在內存中預先放置一些Sequence以使存取速度更快。Cache取完后，Oracle會自動再取一組到Cache 。然而使用Cache可能會跳號，若遇到資料庫突發異常，Cache里的Sequence會丟失。然後創建觸發器：Create Or Replace Trigger MyTrigger Before Insert On TableName referencing old as old new as new for each rowbegin Select MySequence.NextVal To :new.ID From DUAL;end;
[admin via ] Oracle 如何修改一個表欄位的數據為自動增加已經有706次圍觀