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 vote374 views1 answer
Offset in postgresql example
SQL
1 vote530 views3 answers
Create table from existing table in sql
SQL
0 vote352 views1 answer
Convert polygon to text in mysql
SQL
0 vote343 views1 answer
Import big data to mysql
SQL
0 vote313 views1 answer
Como leer datos de mysql esp32
SQL
3 votes343 views1 answer
Oracle revoke
SQL
0 vote339 views1 answer
Mysql regex exact match
SQL
0 vote341 views1 answer
Modificar tipo de dato sql server
SQL
3 votes350 views1 answer
Stpop start psql server
SQL
0 vote372 views1 answer
C# mysql data reader from two tables
SQL