deftran.sql

---------------------------------------------------------------------------
-- Filename:    deftran.sql
-- Purpose:     Reports on all deferred transactions in deftran.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        11-Jun-1998
--
-- Modification History
-- -------------------
-- 11-Jun-1998 : Chas. : Creation
---------------------------------------------------------------------------
col deferred_tran_id heading "Deferred|Tran|ID" format a15

SELECT  deferred_tran_id,
        delivery_order,
        destination_list,
        start_time
FROM    deftran
ORDER BY start_time
/

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.