How to convert full outer join query to O-R query?
- by Kugel
I'm converting relational database into object-relational in Oracle.
I have a query that uses full outer join in the old one.
Is it possible to write the same query for O-R database without explicitly using full outer join?
For normal inner join it simple, I just use dot notation together with ref/deref.
I'm interested in this in general so let's say the relational query is:
select a.attr, b.attr from a full outer join b on (a.fk = b.pk);
I want to know if it's a good idea to do it this way:
select a.attr, b.attr from a_obj a full outer join b_obj b on (a.b_ref = ref(b));
