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 vote123 views1 answer
Sql search all columns of database oracle sql
SQL
4 votes104 views1 answer
Wilayah indonesia database
SQL
4 votes183 views1 answer
Oracle table statistics
SQL
2 votes109 views1 answer
Update trigger
SQL
10 votes110 views1 answer
All_dependencies
SQL
0 vote114 views1 answer
My sql data file extention
SQL
3 votes106 views2 answers
How to list columns for particular tables in postgresql
SQL
22 votes106 views6 answers
Create sql table
SQL
4 votes130 views2 answers
Linq join
SQL
0 vote120 views1 answer
Sql: extract day text from datetime value
SQL