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

5 votes203 views1 answer
Oracle scan source ddl
SQL
11 votes217 views2 answers
Having clause in sql
SQL
10 votes207 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote203 views1 answer
Stop mysql server mac
SQL
1 vote197 views1 answer
Type int in mysql maxlenght
SQL
0 vote208 views1 answer
Mysql Like(searching in the string)
SQL
1 vote205 views1 answer
Sql order by timestamp
SQL
11 votes201 views2 answers
MySQL DISTINCT
SQL
0 vote219 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote230 views1 answer
Cahnge column name apex oracle
SQL