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 vote273 views1 answer
Postgres : ERROR: division by zero
SQL
2 votes251 views1 answer
Match in sql server
SQL
6 votes277 views5 answers
Sql add months to date
SQL
6 votes273 views5 answers
Alter table oracle
SQL
1 vote264 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote275 views1 answer
Mysql copy table1 to table2
SQL
2 votes253 views1 answer
Mysql list users on ubuntu
SQL
0 vote259 views1 answer
Left join in codeigniter query builder
SQL
1 vote272 views2 answers
How to check if sql query is correct online
SQL
1 vote290 views1 answer
Mysql check if string contains comma separated
SQL