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 vote296 views3 answers
How to run sql query
SQL
0 vote277 views1 answer
Foreign key multiple columns
SQL
0 vote296 views2 answers
Mysql calcular idade
SQL
0 vote266 views1 answer
Replace \n sql
SQL
0 vote345 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote281 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes263 views2 answers
Join update query in sql
SQL
0 vote259 views1 answer
Select other columns with distinct
SQL
0 vote229 views1 answer
Mysql insert with foreign key
SQL
7 votes277 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL