title: Left Outer Join using + sign in Oracle 11g
body: <p>Can any one tell me whether below 2 queries are an example of Left Outer Join or Right Outer Join??</p>
  
  <pre><code>Table Part:
  Name         Null?       Type
  PART_ID      NOT NULL    VARCHAR2(4)
  SUPPLIER_ID              VARCHAR2(4)
  
  PART_ID SUPPLIER_ID
  P1      S1
  P2      S2
  P3  
  P4  
  
  Table Supplier:
  Name            Null?     Type
  SUPPLIER_ID NOT NULL      VARCHAR2(4)
  SUPPLIER_NAME   NOT NULL  VARCHAR2(20)
  
  SUPPLIER_ID  SUPPLIER_NAME
  S1           Supplier#1
  S2           Supplier#2
  S3           Supplier#3
  </code></pre>
  
  <p>Display all the parts irrespective of whether any supplier supplies them or not:</p>
  
  <pre>
  SELECT P.Part_Id, S.Supplier_Name
  FROM Part P, Supplier S
  WHERE P.Supplier_Id = S.Supplier_Id (+)
  
  SELECT P.Part_Id, S.Supplier_Name
  FROM Part P, Supplier S
  WHERE S.Supplier_Id (+) = P.Supplier_Id
  </pre>