SELECT
(CASE WHEN 2 BETWEEN 2 AND 3 THEN '[' ELSE '(' END)
||'   '||
(CASE WHEN 1 BETWEEN 1 AND 2 THEN ']' ELSE ')' END)
as testbetween
FROM dual
posted on 2012-05-12 11:18  寒云  阅读(401)  评论(0编辑  收藏  举报