Re: TRIGGERS

Comments inline:
On 5/18/05, david wendelken <davewendelken_at_earthlink.net> wrote:
>
> The only time you need to worry about it is if the id field fills up
> (numbers are up to 38 digits, not too likely a problem for most systems),

Approximately 3.17 * 10^26 years at 1,000,000 inserts per second Yes, probably not a problem for most systems :)

or if you create the data in a test database and import it into production
> database (or vice-versa). Then you have to increment the sequences to equal
> the highest value in the id field. That's a pretty simple pl/sql script to
> write, and not something you need to do everyday. Given a reminder in a week
> or so, I would even such a script and share it with you. Or, someone may
> already have one handy and beat me to it!

http://www.jaredstill.com/content/reset-sequence.html

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l