What's the (+) at the end of the request?
I am completely new to sql oracle and just ran into a query that looks something like this.
SELECT some_field
FROM some_table
WHERE some_other_field=some_value(+);
I have simplified and anonymized the code, but I'm curious about the end (+)
. I don't remember this happening in the mssql world.
source to share
The syntax for the old Oracle outer join is:
To write a query that outer joins tables A and B and returns all rows from A (left outer join), use the LEFT [OUTER] JOIN syntax in the FROM clause, or apply the outer join operator (+) to all columns of B in the join condition in WHERE clause. For all rows in A that do not have matching rows in B, Oracle Database returns null for any list select expressions that contain columns B.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm
source to share