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
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,276
Downloads 430
CodeID
DB ID
ANmarAmdeen
614
Revisions
v1.0
Sunday
December
22
2019