Home » SQL & PL/SQL » SQL & PL/SQL » Getting the column name from USER_IND_EXPRESSIONS (Oracle10g,, Windows)
Getting the column name from USER_IND_EXPRESSIONS [message #335401] Tue, 22 July 2008 01:25 Go to next message
Messages: 1
Registered: July 2008
Junior Member
We're using Oracle in Windows.

I have a problem when retrieving the column name of function-based index.

For example the query:


would result to:


I would like to get the value MY_COL. I tried to manipulate it using some string functions, but it returns an error since COLUMN_EXPRESSION is of type LONG.

What would be the best way to retrieve the column name a of function-based index?

Re: Getting the column name from USER_IND_EXPRESSIONS [message #335416 is a reply to message #335401] Tue, 22 July 2008 02:23 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Write a parser.
Seriously, who says that you only use column-names in your function?
Previous Topic: Partitioning a table
Next Topic: Problem with Oracle Keyword
Goto Forum:

Current Time: Fri Oct 21 06:40:46 CDT 2016

Total time taken to generate the page: 0.10958 seconds