「Oracle」where条件にNULLを指定するサンプル
書式
DELETE FROM テーブル名 WHERE 列名 IS NULL;
使用例
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;
使用例
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;