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

1 vote129 views1 answer
Select statement to print longest name
SQL
1 vote147 views2 answers
Sql insert timestamp
SQL
0 vote145 views1 answer
Empty table sqlite
SQL
10 votes145 views3 answers
Sql check double value
SQL
3 votes128 views1 answer
Postgresql if null then 0
SQL
0 vote126 views1 answer
Dump only schema
SQL
0 vote167 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote150 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote147 views1 answer
Sql convert unix time to date
SQL
0 vote136 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL