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

3 votes145 views1 answer
Sql multiple column index
SQL
0 vote180 views1 answer
Mysql date without time
SQL
2 votes155 views1 answer
Match in sql server
SQL
1 vote152 views1 answer
Mysql get domain from url
SQL
0 vote167 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
4 votes159 views3 answers
How to describe a table in sqlite3
SQL
3 votes112 views4 answers
Mysql delete duplicate rows
SQL
14 votes175 views3 answers
Inner join sql oracle
SQL
0 vote158 views2 answers
Identity column in sql server
SQL
1 vote155 views1 answer
How to subtract from the value of a table in sql
SQL