This discussion is archived
4 Replies Latest reply: Mar 7, 2013 1:52 PM by Don Kleppinger RSS

Is outer join allowed in VL between declarative mode vos?

user523969 - oracle Newbie
Currently Being Moderated
Hi All,

We have a requirement wherein we need to create a VL with LEFT OUTER join type. The two vos participating in this vl are generated with declarative mode (SQL Mode=Declarative selected in the query panel of these vos). Problem is that ADFBC not allowing to add outer join type on vl (basically the query portion of the vl is greyed out) when the participating vos are of declarative type. When SQL Mode changed to "Normal" on vos then query portion in the vl gets enabled and we can add left outerjoin.

Can anyone tell how to create a VL with LEFT OUTER join between declarative mode vos?

Thanks,
Eshwar.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points