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

13 votes187 views2 answers
Display users in mysql
SQL
0 vote177 views0 answer
SQL
3 votes141 views2 answers
Mysql sum with condition
SQL
11 votes300 views5 answers
Update table from another table mysql
SQL
0 vote251 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote183 views1 answer
Name '_mysql' is not defined
SQL
0 vote208 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote218 views1 answer
Select lowest values sql
SQL
23 votes203 views5 answers
Sql substring
SQL
0 vote200 views1 answer
Mysql average from two table
SQL