Sequence相关操作命令

<p>1，修改序列：</p>
<p> ALTER SEQUENCE SEQ_STK_MSGRESUSTTMP <br> INCREMENT BY 1 <br> MINVALUE 1 <br> MAXVALUE 99999999999<br> cache 20 <br> CYCLE NOORDER;</p>
<p>2，查找sequence的所有信息</p>
<p><span class="string"><span style="" lang="EN-US"> select * from all_sequences a where a.sequence_name='SEQ_STK_CONTENT';</span></span></p>
<p><span class="string"><span style="" lang="EN-US">3，查找所有sequence</span></span></p>
<p><span class="string"><span style="" lang="EN-US">4，<span style="" lang="EN-US">select * from all_sequences a where a.sequence_owner='STKRTTP';</span></span></span></p>