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

4 votes387 views1 answer
Rename stored procedure in sql server
SQL
27 votes359 views6 answers
Set password mysql
SQL
1 vote384 views1 answer
Sql view where tables have same column name combine results
SQL
23 votes362 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote318 views1 answer
Count column of tables psql
SQL
2 votes351 views1 answer
Oracle percentage
SQL
0 vote340 views1 answer
Oracle synonym procedure dblink
SQL
-1 vote424 views5 answers
Left join sql
SQL
0 vote375 views1 answer
Tinydb add table
SQL
0 vote345 views1 answer
Dump db only triggers mysql
SQL