Oracle database query in PLSQL can change the field data of sj, select id, sj from t for update, but at the same time in the last line to join the total error is the select id, sj from t for update union all select null, sum (sj) from t,
If this is not wrong: select id, sj from t union all select null, sum (sj) from t but can't modify the data, how to modify the data and the last line of the total time limit,
Please advise, thank you!

CodePudding user response:

Separate query, first check summary, query the detail again,

CodePudding user response:

Ok, thank you!

CodePudding user response:

For update certainly not the union all query, union all is connected to the query