SELECT
1 AS TEXT FROM DUAL
UNION
SELECT
1 AS TEXT FROM DUAL
运行结果为下:
SELECT
1 AS TEXT FROM DUAL
UNION ALL
SELECT
1 AS TEXT FROM DUAL
运行结果为下:
SELECT
1 AS TEXT FROM DUAL
UNION
SELECT
1 AS TEXT FROM DUAL
运行结果为下:
SELECT
1 AS TEXT FROM DUAL
UNION ALL
SELECT
1 AS TEXT FROM DUAL
运行结果为下: