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';

 

posted @ 2022-02-22 10:02  Robot-Blog  阅读(125)  评论(0编辑  收藏  举报