How to check that a column is virtual in Oracle?

Question

How to check if a column is virtual in Oracle?

Answer 1

You can use the VIRTUAL_COLUMN USER_TAB_COLS (or ALL_TAB_COLS or DBA_TAB_COLS , depending on what privileges you have and which user owns this table.

 SELECT virtual_column FROM all_tab_cols WHERE owner = <<owner of the table>> AND table_name = <<name of table>> AND column_name = <<name of column>>