SQL>
SQL> create table myTable (
2 event_name varchar2( 100 ),
3 event_date date );
Table created.
SQL>
SQL> show parameters nls_date_format
NAME_COL_PLUS_SHOW_PARAM TYPE
-------------------------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
---------------------------------
nls_date_format string
SQL> insert into myTable ( event_name, event_date )
2 values ( 'Created an Oracle9i DATE value', DATE '2001-10-11' )
3 /
1 row created.
SQL> select * from myTable;
/
EVENT_NAME EVENT_DAT
-------------------------------------
Created an Oracle9i DATE value 11-OCT-01
SQL> drop table myTable;
Table dropped.