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 vote286 views1 answer
Sql developer connect to sql server
SQL
7 votes258 views1 answer
Grant schema permissions postgres
SQL
11 votes301 views1 answer
Creating tables in sql with python
SQL
0 vote277 views1 answer
Mysql foreach insert
SQL
0 vote296 views1 answer
Sql get year from datetime field
SQL
0 vote261 views1 answer
How to count with except in psql
SQL
10 votes301 views2 answers
Mysql alter add foreign key
SQL
0 vote370 views1 answer
Restart serial number for postgres
SQL
1 vote291 views1 answer
Tsql update datetime
SQL
0 vote262 views1 answer
Update set with join pl sql
SQL