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

2 votes121 views1 answer
Oracle to_char number format percentage
SQL
0 vote123 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote126 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote108 views2 answers
MySQL top percent
SQL
23 votes108 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote117 views1 answer
Update set with inner join oracle
SQL
7 votes106 views1 answer
Query delete duplicates
SQL
1 vote120 views1 answer
Data type and their numeric form
SQL
1 vote118 views1 answer
Mysql how to reset primary key
SQL
0 vote132 views1 answer
Set root password mysql xampp
SQL