Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_APPLY_TABLE_COLUMNS

ALL_APPLY_TABLE_COLUMNS displays information about the destination table object columns for the tables accessible to the current user.

Related View

DBA_APPLY_TABLE_COLUMNS displays information about the destination table object columns for all tables in the database.

Column Datatype NULL Description
OBJECT_OWNER VARCHAR2(30)   Owner of the table
OBJECT_NAME VARCHAR2(30)   Name of the table
COLUMN_NAME VARCHAR2(4000)   Name of the column
COMPARE_OLD_ON_DELETE VARCHAR2(3)   Indicates whether to Compare the old value of the column on deletes (YES) or not (NO)
COMPARE_OLD_ON_UPDATE VARCHAR2(3)   Indicates whether to Compare the old value of the column on updates (YES) or not (NO)
APPLY_DATABASE_LINK VARCHAR2(128)   For remote tables, name of the database link pointing to the remote database