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 votes374 views2 answers
Sql constraint check value in list
SQL
0 vote342 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote347 views5 answers
Sql 2nd highest salary
SQL
0 vote349 views1 answer
Sql server python connection
SQL
8 votes322 views2 answers
Alter column name in mssql
SQL
0 vote352 views1 answer
Mariadb errno 121
SQL
0 vote338 views1 answer
Sql server port 1434
SQL
1 vote358 views3 answers
How to filter repeated same result using sql query
SQL
0 vote341 views1 answer
How to get employee having maximum experience in mysql
SQL
13 votes330 views4 answers
Mysql get last row
SQL