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

3 votes241 views3 answers
Mysql auto increment after delete
SQL
0 vote189 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote315 views1 answer
Drop check command
SQL
0 vote206 views1 answer
Sqlplus change user
SQL
0 vote266 views3 answers
Sql parenthetical expression examples
SQL
53 votes605 views6 answers
How to install mysql ubuntu
SQL
7 votes199 views2 answers
MySQL IF without else
SQL
0 vote256 views1 answer
Update database collation in postgresql
SQL
0 vote201 views1 answer
Show the colums of table sql
SQL
22 votes215 views3 answers
Remove all records from table mysql
SQL