Re: A simple oracle question?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 27 Aug 2004 10:27:31 +0200
Message-ID: <42sti0t9l96pqqui7b5c2sn9fdig66hcj5@4ax.com>

On Fri, 27 Aug 2004 16:02:21 +0800, "Benjamin Wang" <zwang2_at_lucent.com> wrote:

>Hey,
>
>could you give some explanation on the following expression:
>AND h.vendor_site_id = i.vendor_site_id (+)
>
>What's means of {+}?
>
>Thanks,
>
>

Outer join. There may be no record in the table referred to by i. Outer joins are a standard RDBMS concept.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 27 2004 - 03:27:31 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Possible Security Breach"
Previous message: Sybrand Bakker: "Re: How should we find out the total redo amount for a transaction?"
In reply to: Benjamin Wang: "A simple oracle question?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US