688: is
689: select substr(column_name, 1, 24) column_name,
690: column_name full_column_name,
691: data_type
692: from all_tab_columns
693: where table_name = p_tab_name
694: and owner = g_pay_schema
695: and column_name not in ('LAST_UPDATE_DATE',
696: 'LAST_UPDATED_BY',
1005: is
1006: select substr(column_name, 1, 24) column_name,
1007: column_name full_column_name,
1008: data_type
1009: from all_tab_columns
1010: where table_name = p_tab_name
1011: and owner = l_owner
1012: and column_name not in ('LAST_UPDATE_DATE',
1013: 'LAST_UPDATED_BY',
1452: is
1453: select substr(column_name, 1, 24) column_name,
1454: column_name full_column_name,
1455: data_type
1456: from all_tab_columns
1457: where table_name = p_tab_name
1458: and owner = g_pay_schema
1459: and column_name not in ('LAST_UPDATE_DATE',
1460: 'LAST_UPDATED_BY',