A column specified with
SYSDATE gets the current system date, as defined by the SQL language
SYSDATE parameter. See the section on the
DATE data type in Oracle Database SQL Language Reference.
The combination of column name and the
SYSDATE parameter is a complete column specification.
The database column must be of type
DATE. If the column is of type
CHAR, then the date is loaded in the form 'dd-mon-yy.' After the load, it can be loaded only in that form. If the system date is loaded into a
DATE column, then it can be loaded in a variety of forms that include the time and the date.
A new system date/time is used for each array of records inserted in a conventional path load and for each block of records loaded during a direct path load.