EBS備忘錄

CREATE GLOBAL TEMPORARY TABLE inv.inv_temp

(

  inventory_item_id   NUMBER,

  begin_quantity      NUMBER,

  balance_quantity    NUMBER

) ON COMMIT PRESERVE ROWS;

CREATE SYNONYM dtn_inv_temp FOR inv.inv_temp;