What is the correct syntax to find column names that are in a view?

I tried:
SELECT Sys_Column_Name FROM Sys_Columns t1, Sys_Tables t2 WHERE t1.SYS_TABLE_ID 
= t2.SYS_TABLE_ID and sys_table_name =
'tvCompanyContact'

but get
<WARNING> No rows exist or satisfy the specified clause.  (2059)

tvCompanyContact is a valid view in the database and does have data when I try 
to browse it.

Reply via email to