Oracle-好记性不如烂笔头-序列及日期时间的插入

create table new_test(
    id int primary key ,
    riqi varchar2(20),
    shijian varchar2(20),
    info varchar2(20)
)
复制

create sequence newTest
--start with 1
--increment by 1
--maxvalue 999999
--cache 50
--cycle
复制

create or replace trigger tri_newtest
before insert
on new_test
for each row
when (new.id is null)
begin
select newTest.nextval into :new.id from dual;
select to_char(sysdate,'YYYY-MM-DD') into :new.riqi from dual;
select to_char(sysdate,'HH24:MI:SS') into :new.shijian from dual;
end;
复制

insert into new_test values ('','','','test')
复制