Strange column name in view.

[WiseEye]

When I look at the columns of a function-based index in 'View table' I see the proper function calls, but when I use a query to pull them out of the user_tab_cols view they come out as things like SYS_NC00009$.

Should I be pulling the column names out of a different view, or is there a way to convert the system code into the proper function call?

 

[Theod]

Hi,

here you find the column-expression

SELECT col.column_name
	  ,expr.column_expression
	  ,col.descend
FROM   all_ind_columns col
LEFT   JOIN all_ind_expressions expr ON (expr.table_name = col.table_name --
										AND expr.index_name = col.index_name --
										AND expr.column_position = col.column_position --
										AND expr.index_owner = col.index_owner)
WHERE  1 = 1
AND    col.index_name = upper('&p_index_name')
AND    col.table_name = upper('&p_table_name')
AND    col.index_owner = '&p_schema'
ORDER  BY col.column_position

 

[WiseEye]

Thank you, though I found a different way that works too.