April 1999
Intermediate to advanced
552 pages
15h 39m
English
-----------------------------------------------------------------------------
-- Filename: defdest.sql
-- Purpose: Lists data from system.def$_destination.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
-----------------------------------------------------------------------------
column dblink heading "DB Link" format a15
column last_delivered heading "Last|Delivered" format 9999999999
column last_enq_tid heading "Last|Enq|TID" format a5
column last_seq heading "Last|Seq" format 999
column disabled heading "D|i|s|a|b|l|e|d" format a1
column job heading "Job" format 9999
column last_txn_count heading "Last|Txn|Count" format 9999
column last_error_number heading "Last|Error|Number" format 999999
column last_error_Message heading "Last|Error|Message" format a19
SELECT dblink,
last_delivered,
last_enq_tid,
last_seq,
disabled,
job,
last_txn_count,
last_error_number,
last_error_message
FROM system.def$_destination
/