create table YK_IN (
VC_ID VARCHAR2(10),
DT_DATE DATE default Sysdate,
VC_CZY_ID VARCHAR2(20),
constraint PK__yk_in__1CF21B97 primary key (VC_ID)
)
oracle中设置缺省值用Sysdate?
我插入新纪录,可该日期字段并没有值???
VC_ID VARCHAR2(10),
DT_DATE DATE default Sysdate,
VC_CZY_ID VARCHAR2(20),
constraint PK__yk_in__1CF21B97 primary key (VC_ID)
)
oracle中设置缺省值用Sysdate?
我插入新纪录,可该日期字段并没有值???
VC_ID VARCHAR2(10),
DT_DATE not null DATE default Sysdate,
VC_CZY_ID VARCHAR2(20),
constraint PK__yk_in__1CF21B97 primary key (VC_ID)
)
SQL> create table YK_IN (
2 VC_ID VARCHAR2(10),
3 DT_DATE DATE default Sysdate,
4 VC_CZY_ID VARCHAR2(20),
5 constraint PK__yk_in__1CF21B97 primary key (VC_ID)
6 );表已创建。SQL> INSERT INTO YK_IN(VC_ID,VC_CZY_ID) VALUES('10','20');已创建 1 行。SQL> COMMIT;提交完成。SQL> SELECT * FROM YK_IN;VC_ID DT_DATE VC_CZY_ID
---------- ---------- --------------------
10 13-5月 -03 20
大家说得很对,感谢!结帐...