日期:2014-05-16 浏览次数:20870 次
WITH TEST AS (
SELECT 'e' AS column1,'e' AS column2,'e' AS column3 FROM DUAL
UNION
SELECT '1' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT '3' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT '4' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT '%a' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT 'b%' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT '%b' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT 'a%' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT 'a*a' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT '^a ^b' AS column1,' ' AS column2,' ' AS column3 FROM DUAL
UNION
SELECT 'abc' AS column1,'eee' AS column2,'ccc' AS column3 FROM DUAL
)
SELECT * FROM TEST WHERE '1' = '1' and column1 not like 'a%' or 'xxxx' LIKE column1