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 vote345 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote389 views1 answer
Mysql extract day from date leading zero
SQL
0 vote339 views1 answer
How to remove default in mysql
SQL
0 vote304 views1 answer
Mysql collation for all languages
SQL
0 vote366 views1 answer
Search mysql database for column
SQL
0 vote365 views1 answer
Mysql enter ubuntu
SQL
0 vote313 views1 answer
Kannst du deine finger trainieren
SQL
0 vote357 views1 answer
Turnicate in mysql
SQL
0 vote378 views1 answer
List all permissions on a table in postgres
SQL
0 vote380 views1 answer
Default order by in mysql
SQL