Random GUID

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

CodeFunctionName
What is this?

Public

Tested

Original 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 1,245

Downloads 409

CodeID
DB ID