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

1 vote240 views3 answers
Date_add mysql
SQL
2 votes168 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
8 votes173 views1 answer
How to check mysql version in xampp
SQL
1 vote166 views1 answer
How to remove identity from a column in sql server
SQL
0 vote167 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote180 views1 answer
Casterar postgres
SQL
0 vote172 views2 answers
Temp tables in sql server
SQL
0 vote173 views1 answer
Sql select upcoming birthdays
SQL
5 votes169 views3 answers
Truncate function in sql oracle
SQL
7 votes171 views2 answers
Get database size mysql
SQL