0 votes
1 view
in SQL by (3.3k points)

Just i have came across a SQL query in one of the stored procedure like below:

SELECT 
    * 
FROM 
    account a, 
    performance p,
    customer c, 
    override o
WHERE 
    a.account_id = p.account_id (+)
    AND a.account_id = c.account_id (+)
    AND o.override_type(+) = 'O'

Can you please explain what is the (+) symbol's play here? and the difference of using Left side and right side.

1 Answer

0 votes
by (6.8k points)

This symbol refers to old syntax to implement outer join in oracle. But now it’s better to go with full outer, Left, or right join syntax provided by SQL.

Related questions

0 votes
1 answer
asked Feb 16 in SQL by adhiraj (3.3k points)
0 votes
1 answer
asked Feb 12 in SQL by adhiraj (3.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...