Oracle list columns

-- Depending on connected user grants:
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- User tables
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- Available to user
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- All schemas

-- Columns from all tables in a schema (adapt with USER_..., DBA_... or ALL_...):
SELECT c.TABLE_NAME, c.DATA_TYPE FROM ALL_TAB_COLS c
JOIN ALL_TABLES t ON t.OWNER = c.OWNER
WHERE OWNER = 'my_schema';

Oracle list columns in schema

SELECT *
FROM all_tab_cols;

Source: stackoverflow.com

Similar codes

0 vote138 views1 answer
Ignore case in string sql
SQL
1 vote140 views2 answers
T-sql random number for each row
SQL
0 vote144 views1 answer
Mysql date only no time
SQL
0 vote141 views1 answer
Get substract count sql
SQL
19 votes165 views6 answers
Create table sqlite
SQL
2 votes163 views1 answer
Laravel sql String
SQL
3 votes144 views1 answer
Fk in insert mysql
SQL
0 vote101 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote151 views1 answer
Create table like sql
SQL
1 vote145 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL