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 votes156 views1 answer
Oracle asynchronous query
SQL
0 vote137 views1 answer
Create relationship with betwen two tables in postgersql
SQL
25 votes155 views1 answer
How to update an attribute in MySQL
SQL
0 vote156 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote157 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote133 views1 answer
Price-colour
SQL
1 vote128 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote139 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote150 views1 answer
Postgresql select fast check no rows
SQL
0 vote130 views1 answer
Create table with primary key and foreign key in sql server
SQL