glufke.net

Selecionar tudo

SQL> select p.part_id, s.supplier_name
  2  from part p, supplier s
  3  where p.supplier_id = s.supplier_id (+)
  4  union
  5  select p.part_id, s.supplier_name
  6  from part p, supplier s
  7  where p.supplier_id (+) = s.supplier_id;

PART SUPPLIER_NAME
---- --------------------
P1   Supplier#1
P2   Supplier#2
P3
P4
     Supplier#3

Selecionar tudo

SQL> select p.part_id, s.supplier_name
  2  from part p full outer join supplier s
  3  on p.supplier_id = s.supplier_id;

PART SUPPLIER_NAME
---- --------------------
P1   Supplier#1
P2   Supplier#2
P4
P3
     Supplier#3

Selecionar tudo

select a.organization_id,
       a.inventory_item_id,
       a.subinventory_code,
       a.locator_id,
       b.organization_id,
       b.inventory_item_id,
       b.subinventory_code,
       b.locator_id
from nv_una_moviment a FULL OUTER JOIN inv_una_contagens b
   on a.organization_id   = b.organization_id
  and a.inventory_item_id = b.inventory_item_id
  and a.subinventory_code = b.subinventory 
  and a.locator_id        = b.locator_id 
  and a.lot_number        = b.lot_number;

Selecionar tudo

SQL> SELECT A.ENAME, A.DEPTNO, B.DEPTNO
  2  FROM EMP A FULL OUTER JOIN DEPT B
  3    ON A.DEPTNO=B.DEPTNO
  4  /

ENAME         DEPTNO    DEPTNO
---------- --------- ---------
SMITH             20        20
ALLEN             30        30
WARD              30        30
JONES             20        20
MARTIN            30        30
BLAKE             30        30
CLARK             10        10
SCOTT             20        20
KING              10        10
TURNER            30        30
ADAMS             20        20
JAMES             30        30
FORD              20        20
MILLER            10        10
                            40

15 rows selected.

SQL>