VIEW: CTXSYS.CTX_ORDER_BY_COLUMNS

Source

View Text - Preformatted

select
  u.name   obc_index_owner
 ,idx_name obc_index_name
 ,u2.name  obc_table_owner
 ,o.name   obc_table_name
 ,cdi_column_name     obc_column_name
 ,cdi_column_position obc_column_position
 ,cdi_column_type     obc_column_type
 ,cdi_section_name    obc_section_name
 ,decode(cdi_section_type,8,'SDATA',9,'MDATA','UNKNOWN')    obc_section_type
 ,cdi_section_id      obc_section_id
 ,cdi_sort_order      obc_sort_order
 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 OBC_INDEX_OWNER
, IDX_NAME OBC_INDEX_NAME
, U2.NAME OBC_TABLE_OWNER
, O.NAME OBC_TABLE_NAME
, CDI_COLUMN_NAME OBC_COLUMN_NAME
, CDI_COLUMN_POSITION OBC_COLUMN_POSITION
, CDI_COLUMN_TYPE OBC_COLUMN_TYPE
, CDI_SECTION_NAME OBC_SECTION_NAME
, DECODE(CDI_SECTION_TYPE
, 8
, 'SDATA'
, 9
, 'MDATA'
, 'UNKNOWN') OBC_SECTION_TYPE
, CDI_SECTION_ID OBC_SECTION_ID
, CDI_SORT_ORDER OBC_SORT_ORDER
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#