VIEW: APPS.BEN_ALL_TAB_COLUMNS

Source

View Text - Preformatted

SELECT syn.SYNONYM_NAME TABLE_NAME , COLUMN_NAME , DATA_TYPE , DATA_LENGTH , NULLABLE FROM ALL_TAB_COLUMNS tab, USER_SYNONYMS syn WHERE tab.owner = syn.table_owner AND tab.table_name = syn.table_name

View Text - HTML Formatted

SELECT SYN.SYNONYM_NAME TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, DATA_LENGTH
, NULLABLE
FROM ALL_TAB_COLUMNS TAB
, USER_SYNONYMS SYN
WHERE TAB.OWNER = SYN.TABLE_OWNER
AND TAB.TABLE_NAME = SYN.TABLE_NAME