Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Generating a GUID
In OO environments the GUID concept is quite frequent. In OO persistence environments the GUID concept is ALWAYS present. I find really strange that Oracle8i with it's O-R model does not provide a way to generate it...
Anyway, how does Oracle8i manage a situation where you export a table of objects an a table that has references to that objects and than you import that rows in another Db (with the same schema)? How doest it assure that OIDs from the two Db don't collide?
Luca Minudel Consulente Informatico
luca.minudel_at_nline.it Conegliano (TV)
WWW http://www.nline.it/consulting
Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> scritto nell'articolo
<972331077.587.0.nnrp-07.9e984b29_at_news.demon.co.uk>...
>
> How G do you want you UID ?
>
> There is a function SYS GUID() which Oracle
> uses to generate a globally unique ID for objects
> within a database.
> e.g.
> select sys guid() from dual;
>
>
> If you want a really UUID you might do better
> to call to an operating system that supplies them.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> ringosoft_at_my-deja.com wrote in message
<8t235n$fqb$1_at_nnrp1.deja.com>...
> >Is there a way in Oracle 8i to generate a GUID or UUID? If not
> >directly, can I call the OS from a stored proc to do this? On Linux?
On
> >Solaris? TIA.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
>
Received on Mon Oct 23 2000 - 16:29:49 CDT