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 vote164 views1 answer
Psql connect to another database
SQL
0 vote149 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote143 views1 answer
Add created and updatedAt fields in mysql
SQL
1 vote143 views1 answer
Mysql select row max date
SQL
0 vote162 views1 answer
Mysql concatenate select results
SQL
-1 vote153 views3 answers
My sql alter table
SQL
1 vote158 views1 answer
Sql server insert into temp table
SQL
20 votes155 views6 answers
Change password in mysql
SQL
2 votes169 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes144 views3 answers
Mysql check if null or empty string
SQL