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

1 vote163 views1 answer
How to set up a trigger in sql
SQL
1 vote176 views1 answer
Opensuse restart MySQL
SQL
0 vote155 views1 answer
Increase speed of like queries postgres
SQL
2 votes147 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
14 votes146 views4 answers
Remove record from table sql
SQL
0 vote154 views1 answer
Use mysql in java program
SQL
1 vote176 views1 answer
Hangfire clear all jobs
SQL
2 votes226 views2 answers
Set value to null sql
SQL
0 vote187 views5 answers
How to make trigger in phpmyadmin
SQL
20 votes144 views2 answers
Counting in sql
SQL