Re: Is this safe???

From: Chris Forlano <cforlano_at_nortelnetworks.com>
Date: Wed, 29 Sep 1999 18:57:26 +0100
Message-ID: <37F25306.9015E6D@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.

Thanks,

Chris

Thomas Kyte wrote:

> A copy of this was sent to tedchyn_at_yahoo.com
> (if that email address didn't require changing)
> On Mon, 27 Sep 1999 19:08:37 GMT, you wrote:
>
> >thomas, cursor with 'for update of' would do the trick too ?
> >Ted
>
> yes, it would work. it would be terribly inefficient.... sequences are the
> right way.
>

--
Chris Forlano
Automation Development
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Wed Sep 29 1999 - 12:57:26 CDT