I tried my level best to solve this error but it does not work out. I need your
ID: 3761544 • Letter: I
Question
I tried my level best to solve this error but it does not work out. I need your help please. Thank you.
I WANT TO INSERT THE FOLLOWING.
Insert into ORDERS (ORDERNO,CUSTNO,PRODNO,QTYORD,ORDDATE) values ( 1,'A1234','Z1234',2,to_date( ,'04-OCT-96','DD-MON-RR'));
Insert into ORDERS (ORDERNO,CUSTNO,PRODNO,QTYORD,ORDDATE) values ( 2,'A2345','Z1235',3,to_date( ,'08-OCT-96','DD-MON-RR'));
ERROR
SQL> Insert into ORDERS (ORDERNO,CUSTNO,PRODNO,QTYORD,ORDDATE) values ( 1,'A1234','Z1234',2,to_date( ,'04-OCT-96','DD-MON-RR'));
Insert into ORDERS (ORDERNO,CUSTNO,PRODNO,QTYORD,ORDDATE) values ( 1,'A1234','Z1234',2,to_date( ,'04 * ERROR at line 1: ORA-00936: missing expression
Explanation / Answer
I think the format of to_date function you are using is incorrect, try using the one that i have specified