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

6 votes373 views2 answers
Mysql convert timestamp to date
SQL
0 vote346 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
7 votes347 views2 answers
Add column table pl sql
SQL
0 vote373 views1 answer
Change date format in oracle query
SQL
6 votes359 views1 answer
Postgresql add enum value
SQL
7 votes350 views2 answers
Create index mysql cli
SQL
0 vote328 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
-1 vote304 views1 answer
How to format tables in sqlplus
SQL
0 vote345 views1 answer
Mysql insert into select transaction c#
SQL
8 votes361 views1 answer
My sql version
SQL