HOW TO RESET A SEQUENCE
421909Feb 17 2010 — edited Feb 17 2010Hello , One of our sequence generating 5 digit number and it has to be inserted in a table column with NUMBER(4) datatype. By this its generating precesion error. How to solve the problem . Note that , the 4 digits number is specified in other referencial tables too. Kinldy suggest me to resolve it.