April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: gendeltran.sql
-- Purpose: Generates calls to dbms_defer_sys to delete transactions
-- for a particular table.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
select
'exec dbms_defer_sys.delete_tran('||chr(39)||deferred_tran_id||chr(39)||','||
chr(39)||'PLV2.EXCITE.COM'||chr(39)||');'||chr(10)||'commit;'
from deftran t
where exists
(select DEFERRED_TRAN_ID from defcall c
where c.DEFERRED_TRAN_ID = t.DEFERRED_TRAN_ID
and c.packagename like upper('&target_table$%'))
/