UPDATE fr_report_task
SET task_name =
CASE
WHEN task_id = '05691e5afa1e405d97eded85ef5ef3e8'
AND fiscal = 2021
AND task_code = '2020'
AND agy_code = '101' THEN
task_name = '2020部門決算報表'
WHEN task_id = '6bf2655f0a5e49bd9abe9bd18bf14f7e'
AND fiscal = 2021
AND task_code = '2019'
AND agy_code = '101' THEN
task_name = '2019部門決算報表(標準--第三版)'
WHEN task_id = '9b834976585a49cdb107626c6f7c6303'
AND fiscal = 2021
AND task_code = '2020'
AND agy_code = '101' THEN
task_name = '2020部門決算報表'
WHEN task_id = 'b83b5b673dee40dea417c7cf07b6b535'
AND fiscal = 2021
AND task_code = '2020'
AND agy_code = '101' THEN
task_name = '2020部門決算報表'
WHEN task_id = 'd4eb1a0236da488ea3524a19c80dc5b3'
AND fiscal = 2021
AND task_code = '2020'
AND agy_code = '101' THEN
task_name = '2020部門決算報表'
WHEN task_id = 'e1a4d5ec0c59474a80473aed9a8785b5'
AND fiscal = 2021
AND task_code = '2020'
AND agy_code = '101' THEN
task_name = '2020部門決算報表'
WHEN task_id = 'f159f243868347cda48df543f14f3a1d'
AND fiscal = 2021
AND task_code = '0001'
AND agy_code = '101' THEN
task_name = '固定報表'
END
> ORA-00905: missing keyword什么原因
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/261117.html
標籤：開發
上一篇：求大神解答下效率問題