SQL Query to find all columns in a database :

select OWNER, TABLE_NAME, COLUMN_NAME from dba_tab_columns;