SELECT Question

[sqlbeginner1968]

I want to write a SQL statement that says
SELECT column_name
FROM __________________

The FROM should be all tables. I have tried saying FROM * but I get an Invalid Table Name error when I do that.

Any help would be appreciated.

[rmiao]

Can't do, one table at a time.

[sqlbeginner1968]

Thanks for answering my question. I was afraid that might be the answer.

[skhanal]

What is the requirement for doing that?. You can get data from multiple table using UNION

select col
from table1
union
select col
from table2

[sqlbeginner1968]

Success! The following sql worked!

select table_name, column_name
from user_tab_columns
order by table_name

[skhanal]

Ok, if you are looking for all table and column names in a database schema that is the query for Oracle. It was not clear from your original posting.