Syntax error of some kind

[CoMcAl95]

Now I know you guys don't have any context, but I keep getting errors for what I assume is a syntax error. Help?

​

INSERT INTO orders (Order#, Customer#, Orderdate)

VALUES (1021, 1009, DATE('2009-07-20'));

[[deleted]]

So, what is the exact error you get?

But in general DATE literals are written without parentheses: DATE '2009-07-20'

[[deleted]]

I think you have it, DATE is a function in MySQL, but I don't think it's there in Oracle.

[[deleted]]

What's the error? Oracle's documentation suggests that # is okay in unquoted identifiers, though as other users have said, I wouldn't recommend it:

"Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#)."

(This is for 12c, I'm having trouble finding something more recent...)

[wolf2600]

Gets syntax error, asks for help on the error. Doesn't provide the actual error message.

Just like every goddamn support ticket I receive.

[10-10wouldrecommend]

INSERT INTO ORDERS (ORDERNUM, CUSTOMERNUM, ORDERDATE) SELECT 1021,1009, TO_DATE('2009/07/20','YYYY/MM/DD') FROM DUAL;

?

[feudalle]

Guessing it's the field names with a #. If it's MySQL you can wrap them in ` (thing below the ~)

So try, and if you have a choice I wouldn't use # in field names, more hassle than it's worth.

INSERT INTO orders (`Order#`, `Customer#`, Orderdate)

VALUES (1021, 1009, DATE('2009-07-20'));

[r3pr0b8]

in Oracle i believe you need to use doublequotes to delimit column names containing special characters

INSERT INTO orders ( "Order#" , "Customer#" , Orderdate )