Question : oracle find all tables with column name
Answered by : famous-flatworm-06w41cjggpby
-- Oracle-specific
-- all_tab_columns is a magic table listing all columns from all tables
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';
Source : https://www.thepolyglotdeveloper.com/2015/01/find-tables-oracle-database-column-name/ | Last Update : Wed, 10 Mar 21
Question : oracle find all tables with column name
Answered by : vastemonde
SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Other schemas
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- All tables
Source : | Last Update : Sun, 16 May 21