I am trying the following update statement in oracle sql but keep getting the command not properly ended error message. Am I missing something or can it not be done in oracle? Using toad for oracle. Thanks
update cc set
cc.bc_dt = null
from cc
inner join cr on cc.clb_id = cr.clb_id
where cc.cl_n = 3343
and cr.bldr_id = '8843'
and cr.bci_id is null
