Oracle SQL Developer date format
Recently, I use the SQL statement like this INSERT INTO Table_Name VALUES(12-JUN-97); But it give me a error description about the missing column , and error code of . My syntax/statements are1 not short as above , but since others data type is VARCHAR2 and NUMBER thus I can quickly identify the problem come from the DATE . Then, I Google and found that many others people also face the problem on the same error code, may be your error is not similar with me but I would like to share solution on the problem I have faced for almost half hour that can be solve in few minute. Hope that people that have same problem like me can solve it once see my post. The error can be easily fixed by adding '12-JUN-97 ' into the date instead of 12-JUN-97 . Another problem face by my friend is the date format of the ORACLE SQL DEVELOPER is not as the 12-JUN-97. So to change the time format you can follow the instruction below and have ...
