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 vote345 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote159 views1 answer
Tsql generate rows
SQL
0 vote186 views1 answer
Mysql change innodb to myisam
SQL
0 vote169 views1 answer
Concatenate columns in table
SQL
11 votes179 views2 answers
Safe mode off mysql
SQL
0 vote197 views1 answer
Mysql join only one column
SQL
0 vote173 views1 answer
Sql developer search all packages for text
SQL
0 vote223 views1 answer
CONVERT time string into 12 hours in sql
SQL
41 votes260 views6 answers
Alter table add column in SQL Server
SQL
0 vote265 views1 answer
Import sql dump into postgresql database
SQL