Oracle list columns

-- 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 vote232 views1 answer
Group by max date
SQL
3 votes204 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote236 views1 answer
Select top 3 sql
SQL
34 votes240 views6 answers
Install mysql client ubuntu
SQL
-2 votes252 views1 answer
Trunc in sql
SQL
0 vote193 views1 answer
Sql insert tuple
SQL
0 vote196 views1 answer
Change role postgres
SQL
0 vote193 views1 answer
Inner joint
SQL
0 vote201 views2 answers
How to create a table from another table in sql derby
SQL
28 votes196 views4 answers
Delete database mysql
SQL