Random GUID

Generate a random GUID using oracle db workbench
Also add timestamp to ensure randomness


Public

Tested

My Own Work
Select sys_guid() from dual

Will generate a row like below
88FDC68C75DDF955E040449808B55601
88FDC68C75DEF955E040449808B55601
88FDC68C75DFF955E040449808B55601

Or
Select Concat(SYS_GUID(), To_Char(SYSTimeStamp, 'yyyymmddhhmiss')) GUID_Time From Dual

To generate GUID with time stamp to make it more unique

Views 148 Downloads 33

SQL Protection
ANmarAmdeen
674
Attachments
Revisions

v1.0