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

17 votes149 views2 answers
T_sql contains
SQL
0 vote147 views1 answer
Mysql root permission denied lost
SQL
9 votes131 views2 answers
Get first 3 letters in sql
SQL
1 vote132 views1 answer
T-sql find object by name
SQL
0 vote140 views1 answer
Oracle sql developer closed connection
SQL
0 vote178 views1 answer
Wordpress sql find and replace
SQL
0 vote132 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote153 views1 answer
Sql drop default
SQL
0 vote129 views1 answer
Tsql generate rows
SQL
1 vote132 views1 answer
Copy postgres table from one schema into another
SQL