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 vote397 views1 answer
Restart serial number for postgres
SQL
-1 vote299 views1 answer
Sql add column bit
SQL
0 vote300 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote292 views1 answer
Install ms sql server management studio
SQL
1 vote309 views3 answers
Sql server get week dates from week number
SQL
15 votes316 views7 answers
MYSQL
SQL
0 vote320 views1 answer
Mysqli last row
SQL
0 vote313 views1 answer
Postgres drop type
SQL
3 votes307 views1 answer
Force using index plsql
SQL
2 votes329 views3 answers
Sql truncate table
SQL