使用 default 和 default on null 减少编写触发器和序列的需要。

create table default_value_test (

   id                         number GENERATED ALWAYS AS IDENTITY primary key,

   date_created               timestamp with local time zone default on null localtimestamp,

   another_column             varchar2(4000)

   )

insert into default_value_test (another_column) values ('testing')

 

select * from default_value_test

 

insert into default_value_test (date_created, another_column) values (null, 'testing again')