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

Filed under:
|

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

Related posts about sql

Related posts about Oracle