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

1 vote289 views2 answers
Mysql type conversion
SQL
35 votes304 views6 answers
Postgres
SQL
0 vote300 views1 answer
Where name ends in SQL
SQL
0 vote311 views1 answer
Generate random & unique mysql string
SQL
20 votes277 views5 answers
Mysql reset auto increment to 1
SQL
1 vote298 views1 answer
Find difference in dates sql
SQL
0 vote297 views1 answer
Ksql quickstart docker
SQL
4 votes291 views2 answers
Bulk kill mysql processlist
SQL
3 votes293 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote317 views1 answer
Select a row include list of array with join table SQL
SQL