0

Possible Duplicates:
metadata for determining unsed columns
How can you tell which columns are unused in ALL_TAB_COLS?

Hi, I have to fetch only used column names from all_tab_cols only not unsused ,may i know hidden_column column is marked 'Y' for unused_column only or their some other reasons also.

Community
  • 1
  • 1
Vineet
  • 5,029
  • 10
  • 29
  • 34
  • Is this not reall the same as your earlier question? http://stackoverflow.com/questions/3214136/metadata-for-determining-unsed-columns/3218747#3218747 – Tony Andrews Jul 12 '10 at 08:40

1 Answers1

1

In 11g, function-based indexes are implemented as a virtual column (i.e. (column1 + column2)) and are marked as a hidden column.

PenFold
  • 706
  • 3
  • 20