回答編集履歴

推敲

2023/02/27 06:29

投稿

スコア25195

test CHANGED Viewed

@@ -5,10 +5,10 @@
     SELECT
             substr(log.REQUEST_INFO,instr(log.REQUEST_INFO,'cyohyoID:[') + 10) as 帳票ID
           , CASE
-              WHEN user.BUSYO_CD IN (’014’, ’023’) THEN ’〇’
+              WHEN user.BUSYO_CD IN ('014', '023') THEN '〇'
-              WHEN user.BUSYO_CD IN (’064’) THEN ’△’
+              WHEN user.BUSYO_CD IN ('064') THEN '△'
-              WHEN user.BUSYO_CD IN (’065’) THEN ’□’
+              WHEN user.BUSYO_CD IN ('065') THEN '□'
-              WHEN user.BUSYO_CD IN (’066’) THEN ’×’
+              WHEN user.BUSYO_CD IN ('066') THEN '×'
               ELSE code.CODE_NAME
             END as 地域
     FROM