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

Post a Comment