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

2 votes263 views1 answer
Oracle sql concatenate results into string
SQL
0 vote271 views4 answers
Mysql on kubernetes
SQL
0 vote267 views1 answer
Mysql min value row
SQL
5 votes274 views2 answers
Oracle list columns
SQL
1 vote257 views3 answers
Postgresql crete view
SQL
7 votes271 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote262 views1 answer
How to find username and password in oracle 18c
SQL
17 votes259 views5 answers
Order by sql
SQL
1 vote252 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote259 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL