Oracle columns in all_tables

-- 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';

Similar codes

0 vote327 views1 answer
Mysql add to value
SQL
0 vote338 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL
2 votes357 views1 answer
Sql string_agg
SQL
0 vote352 views1 answer
How to start my sql server on mac
SQL
3 votes329 views4 answers
Mysql create table from select statement
SQL
22 votes327 views6 answers
Create sql table
SQL
5 votes349 views2 answers
Sql number columns
SQL
0 vote347 views1 answer
List all indexes postgres
SQL
0 vote366 views1 answer
Is not numeric sql
SQL