Uuid

I wrote about UUIDs in the Oracle database two months back in this post , but it turns out that UUID v4 is so… 2005 . You probably need UUID v7 Head over to How UUIDv7 makes your (database) life easier to understand why you want v7. As mentioned in the article there is no native support for v7 in Oracle, neither a function to generate it or a proper datatype for UUIDs like PostgreSQL has. But the article shows an implementation of v7 generation in a PL/SQL function called generate_uuid_v7 that I used in some testing. ...

Update: I wrote another post about UUID v7 with some alternative solutions. UUIDs are useful, especially when you expose data in REST APIs, but there are cases where you may want to stick to the good old sequence-based primary key. UUIDs in Oracle Database #JoelKallmanDay UUID, short for universally unique identifier, are also known as globally unique identifier (GUID). You can use the function sys_guid() in the Oracle database to generate it: ...