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 vote386 views5 answers
Not in sql
SQL
0 vote343 views1 answer
Mysql auto increment default value with prefix month and year
SQL
5 votes361 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote343 views1 answer
Example of sql querry result sepapreted by comma
SQL
9 votes366 views6 answers
Replace sql
SQL
0 vote363 views1 answer
Less than date query sqlachemy
SQL
2 votes346 views1 answer
Date conversion in mysql column
SQL
0 vote333 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote348 views2 answers
MySQL top percent
SQL
3 votes366 views2 answers
Postgres inner join vs join
SQL