The sequence is generated by Oracle and MySQL respectively.

Sometimes, when inserting data into the database, if the ID value is a 32-bit UUID, but it is not appropriate to write a character by yourself, you need to use a function to generate a sequence value Or

Sometimes, when inserting data into the database, if the ID value is a 32-bit UUID, but it is not appropriate to write a character by yourself, you need to use a function to generate a sequence value Or

Sometimes, when inserting data into the database, if the ID value is a 32-bit UUID,

It is not appropriate to write a character at will, so a function is required to generate a sequence value.

Oracle:

Select sys_guid () from dual;

MySQL:

Select replace (UUID (), '-', '') from dual;

Because the mysql UUID () generation sequence has '-' to be replaced.

You may also like the following:

ORA-01002: fetch out of sequence

Determine whether Oracle sequence exists

Sequence usage in Oracle

Oracle uses triggers and sequence to achieve auto-Growth of primary keys

Sequence restrictions in Oracle

Create auto-increment Field sequence in Oracle

,