Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: do the same without using union all
SELECT
TO_DATE(curr_year || '-' || curr_month || '-' ||
curr_day,'YYYY-MM-DD'),
CASE WHEN i.lv=1 THEN num1 ELSE num2 END num FROM mytab,
(SELECT lv FROM (SELECT LEVEL lv fFROM dual CONNECT BY LEVEL<=2)) i
ORDER BY 1 Received on Thu May 04 2006 - 07:18:01 CDT