Just drop and re-create the sequence.
--
________________________________________
David Williams
"Nermin Tanovic" <hepek_at_hepek.com> wrote in message
news:5cb13885.0204031231.31734a17_at_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:40:06 CST
