「Oracle」カラムの値をNULL値に更新する方法

2021年8月3日

書式
UPDATE テーブル名 SET 列名 = 値[,列名 = 値] [WHERE 条件式];
方法1

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE
USER_TBL
SET
ADDR = NULL
WHERE
UID = '2002';
UPDATE USER_TBL SET ADDR = NULL WHERE UID = '2002';
UPDATE
    USER_TBL 
SET 
    ADDR = NULL
WHERE
    UID = '2002';

方法2

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE
USER_TBL
SET
ADDR = null
WHERE
UID = '3003';
UPDATE USER_TBL SET ADDR = null WHERE UID = '3003';
UPDATE
    USER_TBL 
SET 
    ADDR = null
WHERE
    UID = '3003';

 

Oracle

Posted by arkgame