Virtual column are derived column for other table.
select * from all_tab_cols where virtual_column = 'YES' and owner = USER;