outer_join.txt

orale培训教材包括了所有的sql说明和实例

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;