Oracle list columns in schema

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

Oracle list columns in schema

-- Depending on schema grants:
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- User tables
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- Access granted
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- All schemas

-- Columns from all tables in a schema (or USER_..., DBA_... instead of 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';

Similar codes

0 vote208 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote226 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote212 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote233 views1 answer
Sql tabelle erstellen
SQL
0 vote214 views1 answer
Postgres foreign key multiple columns
SQL
8 votes232 views1 answer
Ltrim sql
SQL
0 vote225 views1 answer
Sql server roles and users
SQL
0 vote209 views2 answers
Select limit ms sql
SQL
24 votes236 views5 answers
List mysql users
SQL
0 vote214 views1 answer
Sql server: how to assign value to table variable returned from function
SQL