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 vote165 views1 answer
Mysql match in serialized data
SQL
8 votes179 views1 answer
Oracle search stored procedures for text
SQL
7 votes182 views1 answer
Oracle reset sequence
SQL
0 vote203 views1 answer
How to check database engine in mysql
SQL
3 votes212 views2 answers
Wp do sql query from function
SQL
1 vote167 views3 answers
What is union in sql
SQL
0 vote191 views1 answer
PSQL qith variables
SQL
0 vote155 views1 answer
Sql injection mitigation
SQL
0 vote174 views1 answer
Get the next column of a table in mysql
SQL
0 vote183 views1 answer
Create table using the clause with as
SQL