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 vote171 views1 answer
Sql script get all stored procedures from database
SQL
0 vote243 views1 answer
Mysql concatenate select results
SQL
0 vote210 views3 answers
Constraint sql
SQL
2 votes201 views4 answers
List databases in sql server
SQL
0 vote210 views1 answer
Oracle running queries
SQL
0 vote202 views2 answers
Mysql calcular idade
SQL
0 vote193 views1 answer
Postgres week number
SQL
16 votes193 views1 answer
Mssql int max value
SQL
0 vote192 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote188 views2 answers
Sql if empty then
SQL