CODEWITHSUNDEEP
oracle-databasedatabase-administrationora-00917
TheDoc
TheDoc

Reputation: 718

ORA-00917 Missing Comma, but it isn't missing?

Doing some Oracle DBA homework and I've looked at several posts about the 00917 error, but I'm just doing a simple INSERT. I can't seem to see where I'm missing a comma or a parenthesis. Any help?

INSERT INTO copy_f_orders 
(ORDER_NUMBER, TO_DATE(ORDER_DATE, 'mm-dd-RRRR'), ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, '09-23-2004', 145.98, 225, 12);

Upvotes: 2

Views: 1083

Answers (3)

krishna bhagodikar
krishna bhagodikar

Reputation: 1

("INSERT INTO copy_f_orders 
(ORDER_NUMBER, TO_DATE(ORDER_DATE, 'mm-dd-RRRR'), ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, '09-23-2004', 145.98, 225, 12)");

Upvotes: -1

Roy Paruchuri
Roy Paruchuri

Reputation: 106

INSERT INTO copy_f_orders 
(ORDER_NUMBER, TO_DATE(ORDER_DATE, 'mm-dd-RRRR'), ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, '09-23-2004', 145.98, 225, 12);

It should be 

INSERT INTO copy_f_orders 
(ORDER_NUMBER, ORDER_DATE, ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, TO_DATE('09-23-2004', 'mm-dd-RRRR'), 145.98, 225, 12);

No point using TO_DATE functions on columns, Hope it makes sense.

Upvotes: 1

Lukasz Szozda
Lukasz Szozda

Reputation: 176104

Don't use function call in column list:

INSERT INTO copy_f_orders(ORDER_NUMBER, ORDER_DATE, ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, '09-23-2004', 145.98, 225, 12);

If you need call it in values:

INSERT INTO copy_f_orders(ORDER_NUMBER, ORDER_DATE, ORDER_TOTAL, CUST_ID, STAFF_ID)
VALUES (5691, TO_DATE('09-23-2004', 'mm-dd-RRRR'), 145.98, 225, 12);

Upvotes: 2

Related Questions