keycols.sql
--------------------------------------------------------------------------- -- 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
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.