ORA-00984: column not allowed here in oracle sql

Question

insert into sales_order
( orderno , clientno , orderdate , delyaddr , salesmanno , delytype , billyn , delydate , orderstatus) 
values 
(
    'O19001',
    'C00001',
    12-jun-2014,
    'Nadiad',
    'S00001',   
    'F',
    'N',
    20-jul-2014,
    'In Process'
);


desc sales_order;
Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ORDERNO                                            VARCHAR2(6)
 CLIENTNO                                           VARCHAR2(6)
 ORDERDATE                                          DATE
 DELYADDR                                           VARCHAR2(25)
 SALESMANNO                                         VARCHAR2(6)
 DELYTYPE                                           CHAR(1)
 BILLYN                                             CHAR(1)
 DELYDATE                                           DATE
 ORDERSTATUS                                        VARCHAR2(10)

question from:https://stackoverflow.com/questions/65895658/ora-00984-column-not-allowed-here-in-oracle-sql

Answer 1

You can use ISO format (YYYY-MM-DD) for the date literals. For example:

insert into sales_order (
  orderno , clientno , orderdate , delyaddr , 
  salesmanno , delytype , billyn , delydate , orderstatus) 
values (
    'O19001',
    'C00001',
    date '2014-06-12',
    'Nadiad',
    'S00001',   
    'F',
    'N',
    date '2014-07-20',
    'In Process'
);