DBA Data[Home] [Help]

SYSTEM.AD_CLONE_UTILS dependencies on DBA_TAB_COLUMNS

Line 153: from dba_tab_columns

149: X_APPS_type_column_exists out nocopy boolean)
150: is
151: cursor c_col is
152: select column_name, data_type, data_type_owner
153: from dba_tab_columns
154: where owner = X_table_owner
155: and table_name = X_table_name;
156: begin
157:

Line 195: from dba_tab_columns

191: is
192:
193: cursor c_col is
194: select column_name, data_type, data_type_owner
195: from dba_tab_columns
196: where owner = X_from_schema
197: and table_name = X_table_name
198: and (data_type in ('LONG', 'LONG RAW')
199: or

Line 365: from dba_tab_columns

361:
362: cursor c_col is
363: select column_name, data_type, data_type_owner, data_length,
364: data_precision, data_scale, nullable
365: from dba_tab_columns
366: where owner = X_from_schema
367: and table_name = X_table_name
368: order by column_id;
369: begin