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 vote404 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
2 votes340 views1 answer
Mysql now format
SQL
-1 vote312 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote339 views1 answer
Mysql get last 2 month data
SQL
6 votes317 views1 answer
To count number of rows in SQL table
SQL
0 vote380 views2 answers
Mysql cast to varchar
SQL
0 vote307 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote352 views1 answer
Sql filter rows with condition
SQL
0 vote318 views1 answer
Install package for sqlserver in asp.net core
SQL
1 vote321 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL