OraFAQ Forum: Forms » Outer join in ORacle forms 6i

Home » Developer & Programmer » Forms » Outer join in ORacle forms 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Outer join in ORacle forms 6i [message #322786]

Mon, 26 May 2008 04:22

rahul15june
Messages: 35
Registered: May 2008

Member

Hi ,

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?

Thanks,
Rahul

Report message to a moderator