Re: Does Oracle i8 create SUID's?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 17 Aug 2001 13:12:00 -0700
Message-ID: <9ljtqg02icm@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 - 15:12:00 CDT