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

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

For example the query:

SELECT COLUMN_EXPRESSION
FROM USER_IND_EXPRESSIONS
WHERE TABLE_NAME = 'MY_TABLE';

would result to:

UPPER("MY_COL")

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
Frank
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: Sat Dec 10 20:17:09 CST 2016

Total time taken to generate the page: 0.13770 seconds