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 vote272 views1 answer
Distance calculator from lat long sql query
SQL
0 vote238 views1 answer
Oarcale list objects
SQL
3 votes261 views4 answers
Ubuntu stop mysql
SQL
0 vote224 views1 answer
Difference between cross apply and inner join
SQL
6 votes222 views2 answers
Return columns from table sql
SQL
4 votes247 views1 answer
Oracle error line
SQL
16 votes259 views2 answers
Mysql date between two dates
SQL
13 votes251 views2 answers
Sqlite rename table
SQL
0 vote231 views1 answer
Bigquery declare
SQL
0 vote325 views1 answer
Delet all record statment sql
SQL