Oracle

Controlling the Order of Rows

Figo Kim 2006. 9. 1. 22:50
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
COLUMN a_dummy NOPRINT
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;

ORDER BY clause can be used only once in a compound query and it should be placed at the very end of the query.


COLUMN : You can use this command to customized column headings.

'Oracle' 카테고리의 다른 글

Set Operator  (0) 2006.09.01
Controlling the Order of Rows  (0) 2006.09.01
How to use dummy column?  (0) 2006.09.01
How to use dummy column?  (0) 2006.09.01
Set Operator Sample.  (0) 2006.09.01