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 vote223 views1 answer
How to delete python anywhere mysql database
SQL
3 votes224 views2 answers
How to force truncate a table in mysql
SQL
6 votes213 views2 answers
Oracle
SQL
0 vote193 views1 answer
Sql transact create cursor with dynamic tables
SQL
10 votes201 views5 answers
Between keyword in sql
SQL
0 vote204 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote258 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote203 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote222 views2 answers
Compound operator in sql
SQL
3 votes224 views1 answer
Mysql insert on dupèlicate
SQL