Monthly Archives: August 2011

To reset existing (Oracle) Sequence.

#Set the value of variable cnt_fx to reset the Oracle Sequence. #Replace owner and SEQUENCE_name with your schema owner and Sequence name. Login to Database and execute below SQLs: set serveroutput on declare cnt integer; — Target sequence number# — … Continue reading

Posted in Shell Script | Tagged | 9 Comments