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 vote263 views1 answer
Create a PostgreSQL user django on mac
SQL
16 votes276 views2 answers
Sql exists
SQL
7 votes256 views1 answer
Query delete duplicates
SQL
0 vote277 views1 answer
Oracle exchange subpartition
SQL
0 vote273 views2 answers
Update all columns in one update
SQL
0 vote258 views4 answers
Sql limit 1 offset 1
SQL
6 votes278 views1 answer
Identify primary key in oracle table
SQL
0 vote287 views1 answer
On delete set default
SQL
1 vote294 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote246 views1 answer
Mysql earlier than date
SQL