Re: Does Oracle i8 create SUID's?

From: Kelly Conboy <conboyka_at_thc-tsg.com>
Date: Fri, 17 Aug 2001 19:52:08 -0400
Message-ID: <9lkajp$8ju$1@bob.news.rcn.net>

Thanks, Thomas, I couldn't find it anywhere. Guess I should have looked for GUID instead of SUID.

Have a great weekend!

Kelly

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9ljtqg02icm_at_drn.newsguy.com...
> In article <9ljskc$9ic$1_at_bob.news.rcn.net>, "Kelly says...
> >
> >Does anyone know if Oracle 8i creates System Unique ID's (SUID)? I
> >understand that there are unique ROWID's created by Oracle on a rowset
> >level. I couldn't find anything in my Oracle 8i Complete Ref. book about
> >SUID's.
> >
> >Thanks,
> >Kelly
> >
> >
>
> sure, lookup sys_guid
>
> ops$tkyte_at_ORA817.US.ORACLE.COM> select sys_guid() from dual;
>
> SYS_GUID()
> --------------------------------
> 8BC05F1405DD002AE034080020884DD6
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Fri Aug 17 2001 - 18:52:08 CDT