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

22 votes243 views4 answers
Mysql reset auto increment id
SQL
6 votes235 views1 answer
Phpmyadmin password root
SQL
3 votes238 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote229 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote224 views1 answer
Find largest table in mysql database
SQL
0 vote247 views1 answer
Sql tablo hangi sp de
SQL
1 vote231 views1 answer
Give a column name to values generated from case statement in sql
SQL
4 votes216 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
8 votes246 views2 answers
Mysql get first x characters
SQL
0 vote242 views1 answer
Sql select max value for each group
SQL