Automatically populate date in oracle table

oracle, time, timestamp

Solution

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.

Problem

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

Original source

Related problems