Re: Does Oracle 8i create SUID's?
Date: 20 Aug 2001 05:27:14 -0700
Message-ID: <178d2795.0108200427.2e9431ac_at_posting.google.com>
"Kelly Conboy" <conboyka_at_thc-tsg.com> wrote in message news:<9ljsiq$9bi$1_at_bob.news.rcn.net>...
> 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
System unique Id's in relation to what? Oracle creates a session id, serial number combination to identify user/oracle sessions connected the database, or you could be asking about a Sequence generator to generate a series of unique numeric keys. See the SQL manual entry for 'create sequence' if this last item is what you want.
Perhaps your are referring to the value returned by the dbms_session.unique_session_id function
- Return an identifier that is unique for all sessions currently
- connected to this database. Multiple calls to this function
- during the same session will always return the same result.
- Output arguments:
- unique_session_id
- can return up to 24 bytes.
If none of this is what you want then please repost with a little more decscription of what kind of identifier you are looking for. Or maybe someone else will recognize the term.
- Mark D Powell --