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

5 votes164 views1 answer
Postgres integer to serial
SQL
13 votes177 views1 answer
Views in sql
SQL
0 vote184 views1 answer
To_date sql
SQL
3 votes167 views3 answers
Remove all spaces from string sql
SQL
3 votes185 views2 answers
Oracle drop column
SQL
0 vote171 views1 answer
Compare two tables to find unmatched records
SQL
0 vote193 views1 answer
Get the next column of a table in mysql
SQL
0 vote184 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote180 views1 answer
Mysql locate
SQL
0 vote173 views1 answer
Add SuperUser MySQL
SQL