April 1999
Intermediate to advanced
552 pages
15h 39m
English
--------------------------------------------------------------------------- -- Filename: keycols.sql -- Purpose: Lists columns identified by DBMS_REPCAT.SET_COLUMNS. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 27-May-1998 --------------------------------------------------------------------------- col sname heading "Schema" format a12 col oname heading "Table Name" format a30 col col heading "Column Name" format a30 clear breaks break on sname on oname skip 1 SELECT sname, oname, col FROM dba_repkey_columns ORDER BY sname, oname / clear breaks