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 vote146 views1 answer
Psql list view rules
SQL
-1 vote140 views2 answers
Postgres autoincrement primary key
SQL
0 vote142 views1 answer
Postgres type equivalent to timespan c#
SQL
18 votes171 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote149 views1 answer
How to query without duplicate rows in sql
SQL
0 vote107 views1 answer
Mysql find foreign key references
SQL
0 vote210 views1 answer
How to add auto increment primary key
SQL
0 vote157 views1 answer
Mysql enter ubuntu
SQL
0 vote225 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote140 views1 answer
Sql find leading space
SQL