SQLexec (nJDEHandle, "select * from all_indexes where trim (upper(table_name)) = 'F7611B'", "CurOracle")and it returned a cursor full of info (below is the display struct of CurOracle), but where do I find the names of the fields that make the index?
Field Field Name Type Width Dec Index Collate Nulls 1 OWNER Character 30 No 2 INDEX_NAME Character 30 No 3 INDEX_TYPE Character 27 Yes 4 TABLE_OWNER Character 30 No 5 TABLE_NAME Character 30 No 6 TABLE_TYPE Character 5 Yes 7 UNIQUENESS Character 9 Yes 8 COMPRESSION Character 8 Yes 9 PREFIX_LENGT.. Numeric 20 Yes 10 TABLESPACE_N.. Character 30 Yes 11 INI_TRANS Numeric 20 Yes 12 MAX_TRANS Numeric 20 Yes 13 INITIAL_EXTE.. Numeric 20 Yes 14 NEXT_EXTENT Numeric 20 Yes 15 MIN_EXTENTS Numeric 20 Yes 16 MAX_EXTENTS Numeric 20 Yes 17 PCT_INCREASE Numeric 20 Yes 18 PCT_THRESHOL.. Numeric 20 Yes 19 INCLUDE_COLU.. Numeric 20 Yes 20 FREELISTS Numeric 20 Yes 21 FREELIST_GRO.. Numeric 20 Yes 22 PCT_FREE Numeric 20 Yes 23 LOGGING Character 3 Yes 24 BLEVEL Numeric 20 Yes 25 LEAF_BLOCKS Numeric 20 Yes 26 DISTINCT_KEY.. Numeric 20 Yes 27 AVG_LEAF_BLO.. Numeric 20 Yes 28 AVG_DATA_BLO.. Numeric 20 Yes 29 CLUSTERING_F.. Numeric 20 Yes 30 STATUS Character 8 Yes 31 NUM_ROWS Numeric 20 Yes 32 SAMPLE_SIZE Numeric 20 Yes 33 LAST_ANALYZE.. DateTime 8 Yes 34 DEGREE Character 40 Yes 35 INSTANCES Character 40 Yes 36 PARTITIONED Character 3 Yes 37 TEMPORARY Character 1 Yes 38 GENERATED Character 1 Yes 39 SECONDARY Character 1 Yes 40 BUFFER_POOL Character 7 Yes 41 USER_STATS Character 3 Yes 42 DURATION Character 15 Yes 43 PCT_DIRECT_A.. Numeric 20 Yes 44 ITYP_OWNER Character 30 Yes 45 ITYP_NAME Character 30 Yes 46 PARAMETERS Memo 4 Yes 47 GLOBAL_STATS Character 3 Yes 48 DOMIDX_STATU.. Character 12 Yes 49 DOMIDX_OPSTA.. Character 6 Yes 50 FUNCIDX_STAT.. Character 8 Yes ** Total ** 869