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 vote234 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote193 views1 answer
Oracle start job
SQL
3 votes254 views2 answers
Find string in stored procedure sql server
SQL
1 vote168 views2 answers
Get date from datetime postgresql
SQL
0 vote156 views0 answer
SQL
1 vote260 views1 answer
Postgresql float 2 decimal places
SQL
0 vote202 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote210 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote195 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
7 votes222 views3 answers
Restore postgres database from sql file
SQL