Reset Sequence value
I have the below script and unable to reset the value . Can somebody fix it...
--@C:\set_sequence_value.sql
set echo off
set heading off
set feedback off
set verify off
undefine SEQ_NAME
undefine NEW_VALUE
undefine OWNER
column passout noprint new_value incby
acc SEQ_NAME CHAR PROMPT 'ENTER SEQUENCE NAME with period :'
acc OWNER CHAR PROMPT 'ENTER SEQUENCE OWNER:'
select rtrim(increment_by) passout from all_sequences where sequence_name=upper('&&SEQ_NAME');
define incb = '&incby'
SELECT 'Current Value is:' || last_number FROM all_sequences where sequence_name=upper('&&SEQ_NAME');
--@C:\set_sequence_value.sql
set echo off
set heading off
set feedback off
set verify off
undefine SEQ_NAME
undefine NEW_VALUE
undefine OWNER
column passout noprint new_value incby
acc SEQ_NAME CHAR PROMPT 'ENTER SEQUENCE NAME with period :'
acc OWNER CHAR PROMPT 'ENTER SEQUENCE OWNER:'
select rtrim(increment_by) passout from all_sequences where sequence_name=upper('&&SEQ_NAME');
define incb = '&incby'
SELECT 'Current Value is:' || last_number FROM all_sequences where sequence_name=upper('&&SEQ_NAME');
0