What is this symbol : (+) ?? [Archive]

View Full Version : What is this symbol : (+) ??

Ishan

06-03-02, 20:35

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 (+)

Sarkarsan

06-04-02, 01:33

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

Ishan

06-04-02, 10:40

Thank you very much