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 vote308 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote292 views1 answer
Sauvegarde complète my sql
SQL
2 votes308 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
4 votes301 views1 answer
Group by mysql and concatenate string
SQL
0 vote332 views1 answer
Mysql average from two table
SQL
6 votes299 views2 answers
Find mysql version linux
SQL
-1 vote243 views2 answers
Datetime sql server week
SQL
0 vote282 views1 answer
Json_remove mysql
SQL
0 vote300 views1 answer
How to declare variable date in mysql
SQL
1 vote311 views1 answer
How to copy data of a table from another database to table of anaother database
SQL