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 vote124 views4 answers
Restart mysql server ubuntu
SQL
0 vote112 views1 answer
Postgresql delete type
SQL
2 votes131 views1 answer
Sql string starts with
SQL
1 vote125 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote105 views1 answer
Query on date sqlite flutter
SQL
0 vote125 views1 answer
Sql select inside select sub query
SQL
0 vote141 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote116 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
2 votes116 views1 answer
Import database in mysql command line xampp
SQL
0 vote118 views1 answer
Flask sqlalchemy decimal
SQL