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 vote130 views1 answer
Sql sum if
SQL
5 votes141 views1 answer
Sql integer to serial
SQL
0 vote128 views1 answer
Mysql case when on date
SQL
0 vote143 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote132 views1 answer
T-SQL Alter the column data type
SQL
0 vote128 views1 answer
Sql right characters
SQL
2 votes188 views2 answers
Mysql date range
SQL
4 votes142 views1 answer
Wilayah indonesia database
SQL
2 votes129 views1 answer
How to add where command in update comand with joins
SQL
1 vote142 views1 answer
Top 10 rows in mysql
SQL