自动在Oracle表中填充日期 [英] Automatically populate date in oracle table

问题描述

我在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.

这篇关于自动在Oracle表中填充日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！