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 vote211 views1 answer
Mariadb select limit offset
SQL
0 vote239 views1 answer
Mysql get nth highest
SQL
1 vote214 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote186 views1 answer
Postgresql subquery
SQL
0 vote210 views1 answer
Oracle show running job
SQL
0 vote207 views1 answer
Create table in dbms cmds
SQL
7 votes219 views3 answers
Postgresql dump and restore db
SQL
0 vote193 views2 answers
Check mysql timezone
SQL
1 vote199 views1 answer
Index a database column sql
SQL
0 vote181 views2 answers
Change database postgres
SQL