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 vote335 views1 answer
Alter column to not null with default value sql server
SQL
0 vote308 views1 answer
Concatenate columns in table
SQL
1 vote330 views1 answer
Copy postgres table from one schema into another
SQL
9 votes307 views4 answers
Mysql show table fields
SQL
0 vote317 views1 answer
Mysqldump don't drop table
SQL
0 vote328 views1 answer
Windows aggregate functions in postgresql
SQL
1 vote354 views1 answer
Database Queries
SQL
6 votes338 views1 answer
Postgres get size of database
SQL
2 votes327 views1 answer
How to delete view in sql
SQL
18 votes333 views4 answers
Mysql current date between two dates
SQL