「Oracle」where条件にNULLを指定するサンプル

2021年8月3日

書式
DELETE FROM テーブル名 WHERE 列名 IS NULL;
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
DELETE
FROM
USER_TBL
WHERE
LOCK_FLG IS NULL;
DELETE FROM USER_TBL WHERE LOCK_FLG IS NULL;
DELETE 
FROM
  USER_TBL 
WHERE
  LOCK_FLG IS NULL;

書式
DELETE FROM テーブル名 WHERE 列名 IS NOT NULL;
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
DELETE
FROM
USER_TBL
WHERE
LOCK_FLG IS NOT NULL;
DELETE FROM USER_TBL WHERE LOCK_FLG IS NOT NULL;
DELETE 
FROM
  USER_TBL 
WHERE
  LOCK_FLG IS NOT NULL;

 

Oracle

Posted by arkgame