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 vote138 views2 answers
How covert into int in maria db
SQL
0 vote139 views1 answer
Get the Db column names from a SqlDataReader
SQL
6 votes118 views4 answers
Mysql update set
SQL
0 vote127 views1 answer
Oracle job class
SQL
3 votes130 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
3 votes132 views1 answer
Oracle transaction commit rollback example
SQL
2 votes140 views2 answers
Postgresql search all tables for column name
SQL
7 votes156 views4 answers
Mysql delete older duplicates
SQL
1 vote193 views2 answers
Sql server find all foreign keys that reference a column
SQL
6 votes136 views4 answers
Remove spaces sql server
SQL