Oracle get table column names

Oracle find all 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 get table column names

SELECT COLUMN_NAME
FROM DBA_TAB_COLS
WHERE table_name = 'my_table';

Column names in oracle sql

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Oracle find all tables with column name

-- Oracle-specific
-- all_tab_columns is a magic table listing all columns from all tables
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';

Source: thepolyglotdeveloper.com

Similar codes

0 vote299 views2 answers
Mysql get routine parameter list
SQL
1 vote300 views1 answer
Sql group by error
SQL
0 vote322 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes328 views3 answers
Current setting postgres timezone
SQL
0 vote309 views1 answer
Java input type sql date
SQL
2 votes286 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
-1 vote309 views3 answers
Psql get last rows
SQL
6 votes305 views2 answers
Mysql check auto increment value
SQL
0 vote324 views1 answer
Frename oracle
SQL
0 vote309 views1 answer
Sql transact create cursor with dynamic tables
SQL