Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 122 of 166
sys_guid::=
sys_guid
SYS_GUID
generates and returns a globally unique identifier (RAW
value) made up of 16 bytes. On most platforms, the generated identifier consists of a host identifier and a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.
The following example adds a column to the sample hr.locations table and inserts unique identifiers into each row, and returns the 32-character hexadecimal representation of the 16-byte raw value of the global unique identifier:
ALTER TABLE locations ADD (uid_col RAW(32)); UPDATE locations SET uid_col = SYS_GUID(); SELECT location_id, uid_col FROM locations; LOCATION_ID UID_COL ----------- ---------------------------------------- 1000 7CD5B7769DF75CEFE034080020825436 1100 7CD5B7769DF85CEFE034080020825436 1200 7CD5B7769DF95CEFE034080020825436 1300 7CD5B7769DFA5CEFE034080020825436 . . .
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|