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 vote182 views1 answer
Grant privileges of databse to user
SQL
28 votes181 views4 answers
Show tables mysql
SQL
1 vote209 views1 answer
Limit offset order by mysql
SQL
0 vote202 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
2 votes196 views2 answers
Sqlite_busy: database is locked
SQL
1 vote168 views4 answers
Sql now
SQL
0 vote174 views1 answer
What is the essence of SQL?
SQL
0 vote189 views1 answer
Get who is hired in february in sql
SQL
1 vote171 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote178 views1 answer
Woocommerce mysql price table
SQL