Re: Is this safe???

The answer is almost certainly yes.

Check out the latest issue of Relate
(if your bit of Nortel has a subscription to the UKOUG), or look at my web-site
for the text of the article on sequences

    Features -> Sequences

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Chris Forlano wrote in message <37F25306.9015E6D_at_nortelnetworks.com>...
>To clarify, what I'm trying to do is create unique id's "across" tables in
different
>schemas.
>For example, I want to ensure that the value for the id column in
user1.test does
>not
>share any ids in the id column of user2.test.
>
>Additionally, I wish to create unique ids based on a record type. For
example, my
>test
>records will have their own unique ids while my package records will have
their own
>unique ids.
>
>Still a case for sequences? Sorry, sequences are new to me.
>
Received on Wed Sep 29 1999 - 13:53:34 CDT