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 vote309 views1 answer
How to get table current identity value in sql server
SQL
1 vote222 views2 answers
Mysql add column tinyint default 0
SQL
0 vote208 views2 answers
Mysql dump structure only
SQL
1 vote195 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote214 views1 answer
Sql select min row
SQL
0 vote340 views1 answer
Sqlite display data in separated columns
SQL
0 vote210 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
2 votes212 views1 answer
Query to find table size in oracle 12c
SQL
3 votes197 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote201 views1 answer
Table valued functions in sql
SQL