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 vote209 views1 answer
Code to move ietms from one table to another myswl
SQL
13 votes229 views3 answers
List all the tables in sql
SQL
3 votes212 views3 answers
Mysqldump: couldn
SQL
0 vote251 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote201 views1 answer
Import big data to mysql
SQL
0 vote265 views1 answer
Sql query tags
SQL
1 vote202 views1 answer
Oracle start job
SQL
0 vote210 views1 answer
Install sql server windows 10
SQL
0 vote209 views1 answer
Prodection ready postgres database step by step
SQL
2 votes227 views2 answers
Install postgresql
SQL