SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Outer Join on a function

274702Jun 12 2002

Hi, can someone tell me if an outer join is allowed on a function , ie

WHERE trunc(A.date_moved_in) = trunc(B.agreement_start_date) (+)

This fails with error 907 - missing right parenthesis. So I assume it is not allowed but the error is misleading and so is the ORACLE documentation in this matter.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2002

Added on Jun 12 2002

6 comments

648 views