CODEWITHSUNDEEP
plsql
Nitin
Nitin

Reputation: 31

Between operator using column(+)

We have a code using column(+) inside between condition. Kindly help in understanding the same : AND b.dat_periodo_rifer BETWEEN a.dat_ini_val(+) AND NVL(a.dat_fin_val(+)- 1,b.dat_periodo_rifer)

Need to understand what is the use of column(+) notation.

Upvotes: 2

Views: 50

Answers (1)

pablomatico
pablomatico

Reputation: 2242

It indicates that the preceding column is the outer join column in a join. Note that Oracle recommends that you use the FROM clause OUTER JOIN syntax rather than the Oracle join operator.

Upvotes: 2

Related Questions