在 oracle 表中自动填充日期
我在 oracle XE 中创建了一个表,并且我有一个类型为 date 的字段.如果可能的话,我希望在我插入一行时,它会自动使用系统中的当前日期填充该字段.
I have created a table in oracle XE, and I have a field with type date. I would like if possible when I insert a row, that it automatically fills that field with the current date from the system.
我正在从 SQL 提示插入行.
I am inserting the rows from the SQL prompt.
谢谢
推荐答案
这里是你需要正确格式化表格的方法:
Here is how, you need to format your table properly:
create table test (first number
, second timestamp default systimestamp
, third varchar2(12));
并且您的默认值始终是格式化为时间戳的当前系统时间.
And your default value is always current system time formatted as timestamp.
相关文章