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 vote313 views1 answer
Database get 10 user aleatory
SQL
2 votes330 views2 answers
Mysql alter column default
SQL
0 vote340 views1 answer
Mql5 datetime get hour
SQL
0 vote362 views1 answer
Mysql workbench format date
SQL
0 vote267 views1 answer
Oracle sysdba connect as another user
SQL
3 votes301 views1 answer
Delete all content in table mysql
SQL
0 vote303 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote324 views1 answer
Get schema of table sql
SQL
3 votes358 views2 answers
Savepoint in sql
SQL
0 vote328 views1 answer
Provide hardcoded value in the mysql query
SQL