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!

What does mean (+) before aliased inline view?

User_6JRTUApr 25 2022 — edited Apr 26 2022

Hello everyone!
I'm sorry for my silly question..
I know than (+) is a special Oracle syntax for outer join. But what does it mean when it used with inline views like that
select *
from
lateral (select ...
from some_table
where...
) (+) tab1
,
lateral (select ...
from other_table
where...
)(+) tab2

This post has been answered by Paulzip on Apr 26 2022
Jump to Answer
Comments
Post Details
Added on Apr 25 2022
4 comments
286 views