SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Confusion with respect to SYS_GUID()

PaulieMay 27 2012 — edited May 27 2012

Hi all,

looking at GUID's for various reasons. According to docco here:

http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions175.htm

SYS_GUID generates and returns a globally unique identifier.

So, I tried but found this

SQL> select sys_guid() from dual;
SYS_GUID()
--------------------------------
C10DFDB6CA494E23E040CC59FBC30BD0
SQL> /
SYS_GUID()
--------------------------------
C10DFDB6CA4A4E23E040CC59FBC30BD0
SQL> /
SYS_GUID()
--------------------------------
C10DFDB6CA4B4E23E040CC59FBC30BD0
SQL> /

SYS_GUID()
--------------------------------
C10DFDB6CA4C4E23E040CC59FBC30BD0

Now, that looks to me like it's returning the same value over and over again. Even when I retype the
command and rerun it, it still gives the same result.

Could any kind soul explain to me what is going on?

TIA and rgs,

Paul...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2012

Added on May 27 2012

12 comments

4,411 views