Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know which column is a VIRTUAL COLUMN in 11g database.

rkpJan 29 2009 — edited Mar 21 2013

Hi All,

I am using database 11g. I have create number of virtual column according to our requirment. But I would like to know which columns are the virtual column from the dictionary tables like (all_tab_columns etc). In which table/view oracle is keeping the information for the virtual columns. (Column name, function name etc).

Regards
SUN

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2013

Added on Jan 29 2009

#general-database-discussions

8 comments

7,679 views