[Home] [Help]
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