April 1999
Intermediate to advanced
552 pages
15h 39m
English
-----------------------------------------------------------------------------
-- Filename: deftrandest.sql
-- Purpose: Lists all databases in deftrandest.
-- 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 a20
col deferred_tran_id heading "Deferred|Tran|ID" format a20
col dblink heading "DB Link" format a20
col start_time heading "Start Time" format a20
SELECT d.deferred_tran_id,
d.delivery_order,
d.dblink,
t.start_time
FROM deftrandest d, deftran t
WHERE d.deferred_tran_id = t.deferred_tran_id
AND d.delivery_order = t.delivery_order
/