What does (+) mean in SQLPlus?

Vince

I just stumbled across a SQL+-Query which uses (+). I've never worked with SQL+ before and I've never seen something like this. I tried to ask Google about it, but I couldn't find anything useful since Google obviously filters the "(+)" and just ignores it...

Example:

[...]
where [...] 
    AND 16791688 = T7mm.child_fielddef_id  (+)  
    AND T7mm.parent_dbid = T7.dbid  (+) 
    AND T1.dbid <> 0 [...]
Randy

it is an Oracle specific shortcut for OUTER JOIN

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

TOP Ranking

HotTag

Archive