37 lines
787 B
SQL
37 lines
787 B
SQL
@@myheader.sql
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
DEFINE owner="&&1"
|
|
DEFINE table="&&2"
|
|
|
|
|
|
PROMPT
|
|
PROMPT *************************************************
|
|
PROMPT * Log table of a master table
|
|
PROMPT *
|
|
PROMPT * Input Parameters
|
|
PROMPT * - owner = '&&owner'
|
|
PROMPT * - table = '&&table'
|
|
PROMPT *************************************************
|
|
|
|
|
|
set lines 256
|
|
|
|
col log_table for a30
|
|
col log_trigger for a30
|
|
col primary_key for a3 head PK
|
|
|
|
select
|
|
log_table
|
|
,log_trigger
|
|
,primary_key
|
|
from
|
|
dba_mview_logs
|
|
where
|
|
log_owner like'&&owner' and master like '&&table';
|
|
|
|
|
|
@@myfooter.sql
|