Hi, I am trying to update a field, in rows, in an existing table, with the contents of a field from another table, and can't get past this error.. ora-01407: cannot update ("GEMMS"."CM_CMPT_DTL"."CMPNT_COST") to NULL.
This is the SQL:
update cm_cmpt_dtl a
set a.cmpnt_cost =
(select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.