http://www.emigar.com/wiki/index.php?action=history&feed=atom&title=Oracle_reset_sequence 2026-05-24T02:02:19Z Cronologia della pagina su questo sito MediaWiki 1.39.0 http://www.emigar.com/wiki/index.php?title=Oracle_reset_sequence&diff=5242&oldid=prev 2014-11-12T15:58:23Z

<p>Creata pagina con &quot; &lt;pre&gt; declare NN number; begin for c1 in (select LAST_NUMBER,INCREMENT_BY,SEQUENCE_NAME,MIN_VALUE,SEQUENCE_OWNER from dba_sequences where sequence_owner=&#039;NDOC&#039;) loop...&quot;</p> <p><b>Nuova pagina</b></p><div><br /> &lt;pre&gt;<br /> declare<br /> NN number;<br /> begin<br /> for c1 in (select LAST_NUMBER,INCREMENT_BY,SEQUENCE_NAME,MIN_VALUE,SEQUENCE_OWNER from dba_sequences where sequence_owner=&#039;NDOC&#039;)<br /> loop<br /> begin<br /> execute immediate &#039;alter sequence &#039; || c1.sequence_owner || &#039;.&#039; || c1.sequence_name || &#039; increment by &#039; || ( (c1.last_number-1) * -1 ) || &#039;&#039; ;<br /> execute immediate &#039;alter sequence &#039; || c1.sequence_owner || &#039;.&#039; || c1.sequence_name || &#039; minvalue &#039; || (c1.min_value - 1) || &#039;&#039; ;<br /> execute immediate &#039;select &#039; || c1.sequence_owner || &#039;.&#039; || c1.sequence_name || &#039;.NEXTVAL from dual&#039; into NN;<br /> execute immediate &#039;commit&#039;;<br /> execute immediate &#039;alter sequence &#039; || c1.sequence_owner || &#039;.&#039; || c1.sequence_name || &#039; increment by &#039; || c1.increment_by || &#039;&#039; ;<br /> execute immediate &#039;alter sequence &#039; || c1.sequence_owner || &#039;.&#039; || c1.sequence_name || &#039; minvalue &#039; || c1.min_value || &#039;&#039; ;<br /> exception<br /> when others<br /> then<br /> null;<br /> end;<br /> end loop;<br /> end;<br /> /<br /> <br /> commit;<br /> select LAST_NUMBER,INCREMENT_BY,SEQUENCE_NAME from dba_sequences where sequence_owner=&#039;NDOC&#039;;<br /> <br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> [[Categoria:Database]]</div>

WikiSysop