I am trying to understand this query but it can't find what the (+) is meaning.

Can you help me ?

select *
from demande_credit_asap d,
pret_debourse_osv p
where d.produitlog = :bien_code
and d.nomarchandlog = :march_no
and (trunc(d.dateouverturelog) >= to_date('1/1/2001','MM/DD/YYYY') and
trunc(d.dateouverturelog) <= to_date('5/7/2002','MM/DD/YYYY'))
and d.noasaplog = p.noasapdebourse (+)

select *
from demande_credit_asap d,
pret_debourse_osv p
where d.produitlog = :bien_code
and d.nomarchandlog = :march_no
and (trunc(d.dateouverturelog) >= to_date('1/1/2001','MM/DD/YYYY') and
trunc(d.dateouverturelog) <= to_date('5/7/2002','MM/DD/YYYY'))
and d.noasaplog = p.noasapdebourse (+)


This means that even if there is no data in pret_debourse_osv corresponding to the record in demande_credit_asap, it should display the data from demande_credit_asap table.
This is called outer join.
So these query will display all the records from the two tables meeting all the criteria and also display all records from d which are qualifying the criteria specified and not matching with the records in table p.

Santosh Sarkar

Thank you very much