Updating multiple fields using update query
tbl_foobar Question ( question_id, foobar Main_id, foobar Question ) tbl_foobar Main ( foobar Main_id, foobar Name, foobar Description ) your database is not normalised as was mentioned before.your answers should be in one table, using an FK to relate them to the questions table.
you really ought to help make it easier for poeple to try to help you.
The solution is everywhere but to me it looks difficult to understand.
Hi Site Point members I have been perusing through the solutions for "updating multiple rows with one query", but I have a pressing question: How would one "SET" multiple column values with one query?
I have used the following Hint in an update query that is executed in Oracle 10G. STG_DEL_CONDITION = x.condition; Thanks and Regards, Karthik Sivakumar.
We recently updated the Oracle to version 11g and when executing the query getting the following Error: ORA-01779: cannot modify a column which maps to a non key-preserved table. Please suggest me some ways that I can do to avoid this error. STG_DEL_CONDITION, t2.condition FROM stg_reports_membenft_latest T1 JOIN (select ods_ssn_grp,sys_id, first_value(STG_DEL_CONDITION) over(PARTITION BY ods_ssn_grp,sys_id ORDER BY STG_DEL_CONDITION DESC) AS condition from stg_reports_membenft_latest) T2 ON T1.ods_ssn_grp = T2.ods_ssn_grp AND T1.