ORACLE Where的条件自动删除右侧空格
-- FALSE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1' = ' '; -- TRUE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' ' = ' '; -- TRUE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' ' = ' '; -- TRUE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1 ' = '1 '; -- FLASE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1 ' = ' 1'; -- TRUE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' 1 ' = ' 1'; -- FALSE SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' 1 ' = ' 1';

浙公网安备 33010602011771号