[Oracle]CASE式で複数な条件のサンプル

2021年7月30日

書式
CASE カラム
WHEN 条件1 THEN 結果1
WHEN 条件2 THEN 結果2
,
ELSE xxx
END
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE
USER_TBL
SET
UID = CASE DEP
WHEN 'AA' THEN '100'
WHEN 'Bv' THEN '300'
WHEN 'Ch' THEN '400'
END
UPDATE USER_TBL SET UID = CASE DEP WHEN 'AA' THEN '100' WHEN 'Bv' THEN '300' WHEN 'Ch' THEN '400' END
UPDATE
      USER_TBL
SET
      UID = CASE DEP
            WHEN 'AA' THEN '100'
            WHEN 'Bv' THEN '300'
            WHEN 'Ch' THEN '400'
      END

 

Oracle

Posted by arkgame