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

1 vote219 views2 answers
Sql select only row with the max date
SQL
0 vote187 views1 answer
Timestamp(0) postgresql
SQL
2 votes175 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote190 views1 answer
Copy data from one postgres container to another
SQL
0 vote196 views1 answer
Python connect to mysql in settings.py
SQL
2 votes181 views6 answers
In in sql
SQL
3 votes205 views1 answer
Define REGEXP?
SQL
4 votes187 views2 answers
Postgre sql create table
SQL
0 vote184 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
2 votes281 views1 answer
Oracle run_duration to number
SQL