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