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 vote289 views1 answer
Oracle simple quote
SQL
0 vote225 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote236 views1 answer
Normalization in database 2nd normal form
SQL
2 votes244 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
37 votes361 views3 answers
Sql check duplicate value in column
SQL
0 vote209 views1 answer
What are the aggregate function in sql
SQL
0 vote227 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote214 views1 answer
Update set with join pl sql
SQL
6 votes260 views3 answers
Rename column ORACLE
SQL
1 vote210 views1 answer
GROUP BY clause; this is incompati
SQL