Yes, (+) is what you need.

Table A Table B
1............1
2............
..............3
4............4

SELECT * FROM TA, TB
WHERE TA.C1 = TB.C1

1..1
4..4

SELECT * FROM TA, TB
WHERE TA.C1(+) = TB.C1

1..1
....3
4..4

SELECT * FROM TA, TB
WHERE TA.C1 = TB.C1(+)

1..1
2...
4..4


HTH,

- Chris