也可以设置默认值;在表结构中设置:
TIMESTP VARCHAR2(24 BYTE) DEFAULT TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') NOT NULL,
TIMESTP VARCHAR2(24 BYTE) DEFAULT TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') NOT NULL,
create or replace trigger test2t
after insert or update on test2
for each row
declare
-- local variables here
begin
update TEST2 set T_TIMESTAMP = sysdate where name = :OLD.name;end TEST2T;
create or replace trigger test2t
before insert or update on test2
for each row
declare
-- local variables here
begin
:NEW.T_TIMESTAMP := sysdate;end TEST2T;
9i中有sys_guid(),不知道你指的是不是这个
14:22:52 SQL> select sys_guid() from dual;
D67A3D806BAD4747A0044728ACFF2998已用时间: 00: 00: 00.00