Oracle tables with column name

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

Oracle columns table

SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';

Similar codes

0 vote219 views1 answer
Postgres foreign key multiple columns
SQL
3 votes161 views1 answer
Two selects in one query
SQL
0 vote165 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
2 votes164 views1 answer
How to find constraints on a table in oracle
SQL
1 vote196 views1 answer
Hackerrank sql test solutions
SQL
0 vote213 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote192 views1 answer
Get foreign table names mysql
SQL
0 vote170 views1 answer
Flask sqlalchemy decimal
SQL
0 vote164 views1 answer
Change schema of all tables postgres
SQL
0 vote188 views2 answers
How to combine two sql queries in one result
SQL