SQL Data Types Oracle PLSQL Tutorial

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.