2021-09-14 oracle != not work on null, not equal not apply null 70 0 oracle != not work on null, not equal not apply null oracle != does not work if the column is null, try nvl(Column, 'nullCol') != 'yourValue'from https://community.oracle.com/tech/developers/discussion/4343867/sql-if-value-is-null-not-equal-does-not-work oracle 回首頁