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 vote240 views2 answers
Amazon linux postgresql client
SQL
-1 vote230 views1 answer
Pl sql drop trigger
SQL
2 votes284 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote255 views1 answer
Create new table from old table
SQL
0 vote227 views1 answer
Sql server select record with max id
SQL
0 vote218 views1 answer
SQL loop with cursor
SQL
9 votes215 views3 answers
Oracle undo usage by session
SQL
1 vote222 views1 answer
List all triggers in SQL Server
SQL
0 vote218 views1 answer
Oracle show grants on table
SQL
2 votes247 views1 answer
Select a certain number of entries from select mysql
SQL