Automatically populate date in oracle table

Question

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.

I am inserting the rows from the SQL prompt.

Thanks

Answer 1

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.