CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   Other Databases (http://www.codingforums.com/forumdisplay.php?f=38)
-   -   Resolved ORACLE: invalid SQL statement (http://www.codingforums.com/showthread.php?t=283586)

WolfShade 12-05-2012 03:27 PM

ORACLE: invalid SQL statement
 
Hello, everyone.

I'm trying to update one column in one table, and I'm getting an "invalid SQL statement" error message from the Oracle database. Could someone please tell me what I'm doing incorrectly?

Code:

UPDATE [schema].[table]
SET status = 'Working'
WHERE create_date = '2012-12-05 08:50:55'

I've tried this with and without TRUNC() and to_Date().

UPDATE: I had code remarked with /* and */ in front of the query. I thought it would be ignored, but apparently it was enough to make the db server think that there was invalid SQL present.

Thanks,


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.