104: all_tab.data_length,
105: all_tab.data_type
106: from
107: all_tab_columns all_tab, 108: all_tables tab 109: where
110: all_tab.nullable in ('N')
111: and all_tab.table_name in (select level_name||'_LTC' from edw_levels_md_v where dim_id=p_dim_id)
112: and tab.table_name=all_tab.table_name
[Home] [Help]