Skip to Main Content

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!

Creating View and ORA-01799, why?

tdobeFeb 1 2022 — edited Feb 1 2022

Hello,
I have select:

select columns
from table a
 left join table2 b on(some complex join);

This select works, then why can't you create a view from it!?
ORA-01799: a column may not be outer-joined to a subquery
That it doesn't work I know, but what is the reason for this? anyone know?

;)

This post has been answered by BluShadow on Feb 3 2022
Jump to Answer
Comments
Post Details
Added on Feb 1 2022
11 comments
1,798 views