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

1 vote115 views1 answer
Oracle stop
SQL
0 vote95 views1 answer
Sql beginning of previous month
SQL
0 vote109 views1 answer
Wordpress sql change site url
SQL
23 votes111 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote99 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote109 views1 answer
What is a Database?
SQL
1 vote123 views1 answer
Sql server read uncommitted
SQL
0 vote122 views1 answer
Check if mysql db is used
SQL
0 vote100 views1 answer
Mysql select all where count more than"
SQL
1 vote97 views2 answers
Drop function in sql
SQL