How to convert full outer join query to O-R query?
Posted
by Kugel
on Stack Overflow
See other posts from Stack Overflow
or by Kugel
Published on 2010-06-08T02:54:37Z
Indexed on
2010/06/08
3:42 UTC
Read the original article
Hit count: 237
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));
© Stack Overflow or respective owner