I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Tuesday, July 17, 2007

Do you know the difference between USER_TAB_COLS & USER_TAB_COLUMNS?

I just noticed the difference - I was wondering why I couldn't see the virtual columns (i.e. columns that support function-based indexes) on a table, and it was because I was querying USER_TAB_COLUMNS.

[Full Article]

No comments:

Post a Comment

Note: only a member of this blog may post a comment.