SQL Data Types Oracle PLSQL Tutorial

By default, you can supply a date with the format DD-MON-YYYY to the database, where:
DD is a two-digit day such as 05
MON is the first three letters of the month such as FEB
YYYY is a four-digit year such as 1968

SQL>
SQL> -- create demo table
SQL> create table Employee(
  2    ID                 VARCHAR2(4 BYTE) ,
  3    First_Name         VARCHAR2(10 BYTE),
  4    Last_Name          VARCHAR2(10 BYTE),
  5    Start_Date         DATE,
  6    End_Date           DATE,
  7    Salary             Number(8,2),
  8    City               VARCHAR2(10 BYTE),
  9    Description        VARCHAR2(15 BYTE)
 10  )
 11  /
Table created.
SQL>
SQL> -- prepare data
SQL> insert into Employee(Start_Date) values ('05-FEB-2005')
  2  /
SQL>
SQL> -- clean the table
SQL> drop table Employee
  2  /
Table dropped.