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

3 votes153 views2 answers
How to delete git repo locally
SQL
150 votes327 views10 answers
Grepper
SQL
0 vote155 views1 answer
Create query in where clasue
SQL
10 votes141 views1 answer
Oracle dba_dependencies
SQL
0 vote144 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote294 views2 answers
Sql unique rows
SQL
2 votes169 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote131 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
1 vote87 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote187 views1 answer
Sql alter table add column if exists
SQL