system-generated column names out of nowhere
Hello. I am trying to figure out why I am seeing the system-generated column names in the output from the following DDL
select index_name, column_name
from dba_ind_columns
where index_name in (select index_name from dba_indexes where table_name = 'CRD_ACCT_RECM_RSPNS_SUM')
and index_owner = 'CAPP'
order by index_name, column_position asc
select index_name, column_name
from dba_ind_columns
where index_name in (select index_name from dba_indexes where table_name = 'CRD_ACCT_RECM_RSPNS_SUM')
and index_owner = 'CAPP'
order by index_name, column_position asc
my output is
CRD_ACCT_RECM_RSPNS_SUM_ALT1 ACCT_NBR
CRD_ACCT_RECM_RSPNS_SUM_ALT1 CUST_TYP_CDE
CRD_ACCT_RECM_RSPNS_SUM_ALT1 RECM_GRP_CDE
CRD_ACCT_RECM_RSPNS_SUM_ALT1 SYS_NC00017$
CRD_ACCT_RECM_RSPNS_SUM_ALT1
0