ORA-00936—The expression is missing.

SELECT syainNo
        , name
        ,date
        ,place
        , time
         FROM YOTEI_DATA_TBL;

I selected what I created in oracle db.

 ORA-00936—The expression is missing.
00936.00000 - "missing expression"
*Cause:    
*Action:
Row 16 Column 5

encountered an error.

I checked and found that the column exists, but the select cannot be executed.
Please give me some advice.

2022-09-30 19:19

1 Answers

I think the reason is that the date and time used for column names are reserved words in Oracle.

As a countermeasure, try to escape by double-quote like "date".

This post was posted as a community wiki based on @ Kazuyuki Deba's comment.

2022-09-30 19:19

Popular Tags

python x 4647

android x 1593

java x 1494

c x 927

c++ x 878

php x 692

html x 656