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 vote288 views1 answer
Jenkins SQLCMD run
SQL
5 votes293 views1 answer
Oracle list functions
SQL
-1 vote293 views1 answer
Mysql select count if contains
SQL
4 votes282 views1 answer
Oracle table statistics last analyzed
SQL
-2 votes302 views2 answers
Union all in sql
SQL
15 votes302 views5 answers
Show tables in oracle
SQL
0 vote277 views1 answer
Check if table exists oracle
SQL
1 vote272 views1 answer
List index mysql cli
SQL
1 vote307 views2 answers
Mysql extract number from string
SQL
0 vote301 views2 answers
Greater than sql server
SQL