COLUMN a_dummy NOPRINT --------------------> a_dummy 열을 출력하지말아라.
SELECT 'sing' AS "My dream", 3 a_dummy
FROM dual
UNION
SELECT 'I''d like to teach', 1 a_dummy
FROM dual
UNION
SELECT 'the world to', 2 a_dummy
FROM dual
ORDER BY a_dummy;
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
10일차 # 8-6: Inserting a row (0) | 2012.04.17 |
---|---|
10일차 # 8 Manipulating Data (0) | 2012.04.17 |
10일차 # 7-20 Matching the SELECT Statement: Example (0) | 2012.04.17 |
10일차 # 7-19 Matching the SELECT Statements (0) | 2012.04.17 |
10일차 # 7-15: MINUS (0) | 2012.04.17 |