outer_join.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 31 行

SELECT product_name FROM plsql101_product ORDER BY product_name;

SELECT prod.product_name,
       prod.product_price,
       purc.purchase_date,
       purc.quantity
FROM   plsql101_product  prod,
       plsql101_purchase purc
WHERE  prod.product_name = purc.product_name
ORDER BY prod.product_name;

SELECT prod.product_name,purc.product_name  name_in_product,
       prod.product_price,
       purc.purchase_date,
       purc.quantity
FROM   plsql101_product  prod,
       plsql101_purchase purc
WHERE  prod.product_name = purc.product_name (+)
ORDER BY prod.product_name;

SELECT prod.product_name,purc.product_name name_in_purch,
       prod.product_price,
       purc.purchase_date,
       purc.quantity
FROM   plsql101_product  prod,
       plsql101_purchase purc
WHERE  prod.product_name (+)= purc.product_name 
ORDER BY prod.product_name;

select *  from plsql101_product;
select *  from plsql101_purchase;