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 vote125 views1 answer
On sql table data exists
SQL
2 votes128 views2 answers
Change mysql password from command line
SQL
0 vote171 views1 answer
How to add auto increment primary key
SQL
3 votes135 views3 answers
Update con select postgresql
SQL
2 votes112 views1 answer
Oracle sql drop column if exists
SQL
4 votes132 views1 answer
List tables sqlite
SQL
0 vote137 views3 answers
Characters found after end of sql statement
SQL
4 votes104 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote112 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote134 views1 answer
Including parameters in OPENQUERY
SQL