默认值为Sysdate

[liyongsheng]

设计表时，如何使某列的默认值为系统当前日期？

[hevin]

create table t1
(
id$ integer not null,
charcol char default 'Y',
datecol date default sysdate,
strcol varchar2(30) default user,
intcol integer default 12
);
insert into t1 (id$) values (1);
select * from t1;

ID$ C DATECOL STRCOL INTCOL
---------- - --------- ------------------------------ ----------
1 Y 28-MAY-04 SCOTT 12

[zhpsam109]

SQL> create table AA
2 (
3 AA DATE default sysdate,
4 BB VARCHAR2(10)
5 )
6 /

Table created

SQL> insert into aa(bb) values('bb');

1 row inserted

SQL> commit;

Commit complete

SQL> select * from aa;

AA BB
----------- ----------
2005-12-21 bb