defcalldest.sql
----------------------------------------------------------------------------
-- Filename: defcalldest.sql
-- Purpose: Lists all calls in defcalldest.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 28-Jun-1996
----------------------------------------------------------------------------
col callno heading "Call No" format 9999999999999
col deferred_tran_db heading "Deferred|Tran|DB" format a19
col deferred_tran_id heading "Deferred|Tran|ID" format a15
col dblink heading "DB Link" format a20
col start_time heading "Start|Time" format a20
SELECT c.callno,
c.deferred_tran_id,
c.dblink,
t.start_time
FROM defcalldest c, deftran t
WHERE c.deferred_tran_id = t.deferred_tran_id
/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.
