How to create a VARCHAR GUID in Oracle Tom · December 16, 2007 Just use this magical incantation: RAWTOHEX(SYS_GUID())