oracle自动生成uuid的实现方法

1

create table t_user(id varchar2(200),name varchar2(200));

1

2

alter table t_user modify id default sys_guid();

update t_user set id = sys_guid();

1

2

3

4

5

6

7

insert into t_user(name) values(pluto);

insert into t_user(name) values(charon);

commit;

select * from t_user;

1

SELECT sys_guid(),rawtohex(sys_guid()) from dual;