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 vote181 views1 answer
Import sql inside hide sql
SQL
3 votes171 views1 answer
Uppercase and lowercase in sql
SQL
1 vote168 views1 answer
How much every mysql database record takes from diskspace
SQL
2 votes175 views1 answer
Mysql create user with remote access
SQL
3 votes178 views1 answer
Oracle sleep
SQL
0 vote208 views1 answer
Cartesian product sql
SQL
1 vote172 views1 answer
Get all db sizes in mysql server
SQL
9 votes159 views3 answers
Mysql get last id
SQL
0 vote122 views1 answer
Expose db in virtualbox
SQL
1 vote175 views1 answer
Mysql best tutorial for beginners
SQL