Home / server / Questions / 52601
Accepted
Paul
Asked: 2009-08-12 00:27:57 +0800 CST

pl/sql Oracle syntax

  • 772

I have a query in pl/sql that i need to migrate to ms sql.

select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+)

Could anyone tell me what the (+) after the column means ? (is it sort of a sum ?)

migration oracle query plsql

1 Answers

  1. Best Answer

    It's an alternate form of specifying an outer join. There are more details here:

    http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/queries006.htm

    • 3