SELECT <<COLUMN NAME>>
FROM <<TABLE NAME>>
[ WHERE ] [ GROUP BY … ]
{ set operator }
SELECT <<COLUMN NAME>>
FROM <<TABLE NAME>>
[ WHERE … ] [ GROUP BY … ]
[ ORDER BY … ]
SELECT <<COLUMN NAME>>
FROM <<TABLE NAME>>
[ WHERE … ] [ GROUP BY … ]
{ set operator }
SELECT <<COLUMN NAME>>
FROM <<TABLE NAME>>
[ WHERE … ] [ GROUP BY … ]
{ set operator }
SELECT <<COLUMN NAME>>
FROM <<TABLE NAME>>
[ WHERE … ] [ GROUP BY … ]
[ ORDER BY … ]
Connected to Oracle Database 11g Release 11.2.0.1.0
Connected as *****
SQL> SELECT 'A', 'B'
FROM DUAL
UNION
SELECT 'C', 'D' FROM DUAL;
'A' 'B'
--- ---
A B
C D
SQL> SELECT 'A' as col1, 'B' as col2
FROM DUAL
UNION
SELECT 'C' as col3, 'D' as col4 FROM DUAL;
COL1 COL2
---- ----
A B
C D
SQL> SELECT 'A' as col1, 1 as col2
FROM DUAL
UNION
SELECT 'C' as col3, 'D' as col4 FROM DUAL;
SELECT 'A' as col1 ,1 as col2 FROM DUAL UNION SELECT 'C' as col3,'D' as col4 FROM DUAL
ORA-01790: expression must have same datatype as corresponding expression
SQL> SELECT 'A' as col1, 'B' as col2
FROM DUAL
UNION
SELECT 'C' as col3, 'D' as col4
FROM DUAL
UNION
SELECT 'E' as col5, 'F' as col6 from DUAL order by 1;
COL1 COL2
---- ----
A B
C D
E F
SQL> SELECT 'A' as col1, 'B' as col2
FROM DUAL
UNION
SELECT 'E' as col3, 'F' as col4
FROM DUAL
UNION
SELECT 'C' as col5, 'D' as col6 from DUAL order by 1;
COL1 COL2
---- ----
A B
C D
E F
SQL> SELECT 'A' as col1, 'B' as col2
FROM DUAL
UNION
SELECT 'C' as col3, 'D' as col4
FROM DUAL
order by 1
UNION
SELECT 'E' as col5, 'F' as col6 from DUAL;
SELECT 'A' as col1, 'B' as col2
FROM DUAL
UNION
SELECT 'C' as col3, 'D' as col4
FROM DUAL
order by 1
UNION
SELECT 'E' as col5, 'F' as col6 from DUAL
ORA-00933: SQL command not properly ended
SQL> SELECT 'A' as col1, 'B' as col2
FROM DUAL
order by 1
UNION
SELECT 'C' as col3, 'D' as col4
FROM DUAL
UNION
SELECT 'E' as col5, 'F' as col6 from DUAL;
SELECT 'A' as col1, 'B' as col2
FROM DUAL
order by 1
UNION
SELECT 'C' as col3, 'D' as col4
FROM DUAL
UNION
SELECT 'E' as col5, 'F' as col6 from DUAL
ORA-00933: SQL command not properly ended
SQL>
SQL> SELECT 'A' as col1, 'B' as col2
2 FROM DUAL
3 UNION
4 SELECT 'C' as col3, 'D' as col4
5 FROM DUAL
6 UNION
7 SELECT 'E' as col5, 'F' as col6 from DUAL order by 1
8 ;
COL1 COL2
---- ----
A B
C D
E F
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (1)
Commented:
Thanks