Is there a way to get around this problem? I am trying to update multiple columns in the same 'update' statement without using a subquery.
update /table_name/
set (column_name, column_name)=(value, value);
ERROR at line 2:
ORA-01767: UPDATE ... SET expression must be a subquery