Database Views

[suki]

I have a VB6 application and I am trying to write code that deals with a database that only uses views (referencing to another full database).

In SQL databases I can find out all the column names for a table using the SQL statement:

SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '" & sTableName & "'"

Does anyone know how I can do something similar in Oracle?

[marist89]

checkout user_tables or user_objects

[ales]

User_tab_columns might help you as well:

select column_name, data_type
from user_tab_columns
where table_name = 'SOME_TABLE'

Ales