Is it possible to have an outer join in oracle forms 6i. I wanted to get all the months along with expense for each month. This is the SQL I came out with,
select a.mon, to_date('01-'||A.Y,'DD-MONTH-YYYY') Z from
(SELECT DISTINCT TO_CHAR(EXP_DATE,'MON') MON, TO_CHAR(EXP_DATE,'MONTH-YYYY') Y FROM EXP_MAIN ) a,
(SELECT to_CHAR(to_DaTE(rownum,'MM'),'MON') themonth FROM user_tab_columns WHERE rownum < 13) b
where a.mon = b.themonth(+)
ORDER BY Z ASC;
However, I get a internal error. When I remove the (+) out join. It compiles properly.
Was wondering, if Forms 6i supports outer join?