VIEW: CTXSYS.CTX_FILTER_BY_COLUMNS

Source

View Text - Preformatted

select
  u.name   fbc_index_owner
 ,idx_name fbc_index_name
 ,u2.name  fbc_table_owner
 ,o.name   fbc_table_name
 ,cdi_column_name fbc_column_name
 ,cdi_column_type fbc_column_type
 ,cdi_section_name    fbc_section_name
 ,decode(cdi_section_type,8,'SDATA',9,'MDATA','UNKNOWN')    fbc_section_type
 ,cdi_section_id      fbc_section_id
 from dr$index_cdi_column, dr$index, sys.user$ u, sys.obj$ o,
      sys.user$ u2
where cdi_idx_id = idx_id
  and cdi_column_position = 0
  and idx_owner# = u.user#
  and idx_table_owner# = u2.user#
  and idx_table# = o.obj#

View Text - HTML Formatted

SELECT U.NAME FBC_INDEX_OWNER
, IDX_NAME FBC_INDEX_NAME
, U2.NAME FBC_TABLE_OWNER
, O.NAME FBC_TABLE_NAME
, CDI_COLUMN_NAME FBC_COLUMN_NAME
, CDI_COLUMN_TYPE FBC_COLUMN_TYPE
, CDI_SECTION_NAME FBC_SECTION_NAME
, DECODE(CDI_SECTION_TYPE
, 8
, 'SDATA'
, 9
, 'MDATA'
, 'UNKNOWN') FBC_SECTION_TYPE
, CDI_SECTION_ID FBC_SECTION_ID
FROM DR$INDEX_CDI_COLUMN
, DR$INDEX
, SYS.USER$ U
, SYS.OBJ$ O
, SYS.USER$ U2 WHERE CDI_IDX_ID = IDX_ID
AND CDI_COLUMN_POSITION = 0
AND IDX_OWNER# = U.USER#
AND IDX_TABLE_OWNER# = U2.USER#
AND IDX_TABLE# = O.OBJ#