测试ORACLE BETWEEN是左右闭合 SELECT(CASE WHEN 2 BETWEEN 2 AND 3 THEN '[' ELSE '(' END)||' '||(CASE WHEN 1 BETWEEN 1 AND 2 THEN ']' ELSE ')' END)as testbetweenFROM dual