connect customer/customer@customer_site


update stock_levels set curr_stock_level = 50 where scu = 1;
commit;
update stock_levels set curr_stock_level = 9 where scu = 1;
commit;


Set Serveroutput On
execute Scan_Customer_Orders

column o   format 9999999999
column v   format 999
column scu format 999

column q   format 999
column d   format a24
column s   format a10
column msg format a60
Set Wrap On
Set LineSize 140
select order_ref o,

       vendor_id v,
       scu,
       quantity q,
       To_Char ( order_date, 'hh:mi:ss::DD-Mon-YYYY'  ) d,
       status s,
       err_msg msg
  from customer_orders;


column m format a140
select err_msg m
  from customer_orders;

--------------------------------------------------------------------------------

connect vendor/vendor@vendor_site
select * from vendor_orders;