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 vote359 views1 answer
Hibernate dialect property xml for mysql 8
SQL
9 votes351 views3 answers
Pyodbc connect to sql server
SQL
0 vote315 views1 answer
Google cloud sql postgres url example
SQL
0 vote330 views1 answer
Drop procedure sql
SQL
12 votes315 views1 answer
Create column sql server
SQL
0 vote339 views1 answer
Drop-toys-table
SQL
0 vote319 views1 answer
SqlFunction does not exist
SQL
0 vote321 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote333 views1 answer
Two inner joins sql
SQL
0 vote365 views1 answer
Sql select without column name
SQL