Find All Columns and Tables in Oracle

Source:
https://www.thepolyglotdeveloper.com/2015/01/find-tables-oracle-database-column-name/

Depending on your access you will use one of the following queries:

-- Standard Users
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';
-- DBA Users
select table_name from dba_tab_columns where column_name = 'PICK_COLUMN';
-- Just want to see what table looks like
describe namespace.tableName

If you want some database tool here are ones I like. I usually go for the ‘kitchen sink’ toolsets:

Updated 5/15 – Add looking for column in a known table

SELECT * 
FROM all_tab_columns 
WHERE table_name = 'MyTableName'
ORDER BY COLUMN_ID;