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

3 votes179 views1 answer
Mssql remove column
SQL
0 vote218 views1 answer
Mariadb change column type
SQL
1 vote223 views1 answer
Psql client write to bash variable
SQL
0 vote178 views1 answer
What is delimiter in mysql
SQL
4 votes183 views1 answer
Wilayah indonesia database
SQL
-2 votes282 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote202 views2 answers
Sql query print strings and int
SQL
23 votes170 views6 answers
How to create table in sql
SQL
4 votes207 views2 answers
Dbms output
SQL
2 votes216 views2 answers
Postgres change owner of schema
SQL