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 vote337 views2 answers
Change database postgres
SQL
0 vote349 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
3 votes345 views3 answers
Concatenation in sql
SQL
0 vote391 views1 answer
Sql int vs integer
SQL
1 vote356 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote341 views1 answer
Oracle add proxy
SQL
1 vote358 views1 answer
Partition by sql server
SQL
0 vote352 views1 answer
Interview experience as a call?
SQL
3 votes351 views2 answers
Oracle drop column
SQL
1 vote565 views3 answers
Sql subquery
SQL