Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Reseting Sequence

Reseting Sequence

From: Nermin Tanovic <hepek_at_hepek.com>
Date: 3 Apr 2002 12:31:32 -0800
Message-ID: <5cb13885.0204031231.31734a17@posting.google.com>


What would be the best way to reset the curent value of the sequence and set it back to 0 from PL/SQL script?

Since Oracle does not have a direct way to do this (which I find strange),
the solution has to be some way around.

I would apretiate your input

thanks and happy coding
Nermin Received on Wed Apr 03 2002 - 14:31:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US