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 vote159 views1 answer
Check if a word appears at the end sql query
SQL
1 vote200 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote206 views1 answer
Nvl postgres
SQL
6 votes195 views1 answer
To count number of rows in SQL table
SQL
0 vote181 views1 answer
Hibernate show sql xml property
SQL
1 vote208 views2 answers
Copy table in sql
SQL
14 votes204 views6 answers
Finding duplicate rows mysql
SQL
0 vote166 views1 answer
Sql server whoami
SQL
1 vote167 views2 answers
T sql get foreign key
SQL
1 vote244 views1 answer
Base64 encode sql server
SQL