Home » Developer & Programmer » Forms » Outer join in ORacle forms 6i
Outer join in ORacle forms 6i [message #322786] Mon, 26 May 2008 04:22 Go to next message
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
Re: Outer join in ORacle forms 6i [message #322946 is a reply to message #322786] Mon, 26 May 2008 22:50 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member



I feel your have to update some batch for d2k.


your one is older version.

kanish
Previous Topic: how to connect lov to push button?
Next Topic: How to get cummulative sum of a column
Goto Forum:
  


Current Time: Tue Dec 06 08:10:18 CST 2016

Total time taken to generate the page: 0.15621 seconds