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

7 votes139 views1 answer
Buy forge mods server hosting
SQL
0 vote102 views1 answer
Sqlalchemy existing database
SQL
0 vote128 views1 answer
Sql get month from date
SQL
2 votes144 views2 answers
Postgres add column integer
SQL
0 vote146 views1 answer
Psql check if sql script is valid
SQL
3 votes138 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
-1 vote154 views1 answer
Mysql extract days
SQL
0 vote118 views3 answers
Sql count condition
SQL
16 votes135 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote147 views1 answer
How to create a new db from dumb file mysql
SQL