Oracle list columns schema

-- 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';

Oracle list columns in schema

SELECT *
FROM all_tab_cols;

Source: stackoverflow.com

Similar codes

0 vote240 views2 answers
How to take recent row without limit in mysql
SQL
1 vote252 views1 answer
Connect to mysql database ubuntu
SQL
1 vote216 views2 answers
Mysql does sentance contain word
SQL
3 votes182 views1 answer
If 0 return null else return query mysql
SQL
0 vote275 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
2 votes221 views1 answer
Oracle index size calculation
SQL
1 vote229 views3 answers
How to get date in sql
SQL
0 vote221 views1 answer
In mysql workbench contnent not feching
SQL
0 vote227 views1 answer
Sql server on mac m1
SQL
0 vote244 views1 answer
Oracle list partitions
SQL