sql - Why oracle DB does not update the fileds -


i not know wrong query not give error , not update row. enddatetime field datatype timestamp.

update test_bank set status = 'received', enddatetime = '16-jun-15 11.21.06.000000000' enddatetime = null ;

enter image description here

see attached screenshot

i believe in oracle syntax checking null following

 enddatetime null 

instead of

 enddatetime = null 

Comments

Popular posts from this blog

java - HTTP Status 500 - An exception occurred processing JSP page /second.jsp at line 15 -

SQL Server - MyCTE query based on 24 hour period (next day) -

php - Using str_replace to translate a MySQL Table in html -