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 vote133 views1 answer
Mysql sum with group by
SQL
2 votes118 views2 answers
How to create an empty table from an existing table
SQL
26 votes133 views2 answers
Mysql workbench download
SQL
-1 vote140 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote140 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote120 views2 answers
Mysql create table if not exists
SQL
14 votes132 views1 answer
Sql value of string
SQL
2 votes138 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote125 views1 answer
How to order result of subquery in select
SQL
0 vote123 views1 answer
Char varchar nvarchar sql
SQL