Re: Unique Instance ID

Tom:

You can do this:

select sys_guid() from dual;

Beginning with 8.1.5, you can use this to get a globally unique ID. It uses a combination of machine id and timestamp.

HTH,
Tom Best

<coderator_at_my-deja.com> wrote in message news:8lhu3g$vgh$1_at_nnrp1.deja.com...
> I need to create a unique global id from within
> Orcale. I know how to make a unique id for any
> particular instance, but I need this id to be
> unique across many possible insances on many
> different machines. Is there a unique serial
> number or instance id I can get to while the
> database is running?
>
> Thanks, Tom
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 24 2000 - 00:00:00 CDT