Breaking News: Grepper is joining You.com. Read the official announcement!

oracle list columns in schema

Add Answer

Jacques_Kirstein answered on March 19, 2020 Popularity 7/10 Helpfulness 5/10

answer oracle list columns in schema

related oracle list columns

related oracle list columns in schema

oracle list columns in schema

Comment

SELECT *
FROM all_tab_cols;

Popularity 7/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: list oracle schema sql

Link to this answer
Share Copy Link

Contributed on Mar 19 2020

Jacques_Kirstein

0 Answers Avg Quality 2/10

Closely Related Answers

oracle list columns

Comment

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

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: list

Link to this answer
Share Copy Link

Contributed on Jan 31 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle list columns in schema

Comment

-- Depending on schema grants:
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- User tables
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- Access granted
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- All schemas

-- Columns from all tables in a schema (or USER_..., DBA_... instead of 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';

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: list oracle schema show sql

Link to this answer
Share Copy Link

Contributed on May 02 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle list columns in schema

Contents

More Related Answers

oracle list columns in schema

Closely Related Answers

oracle list columns

oracle list columns in schema

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.