Query that fetches all table names & column names in a schema

Question

I want to retrieve all table names and column names IN A SCHEMA. So if I am in schema scott it should only show all the tables present in scott.

And can the query below only retrieve the tables in a schema?

Select * from tab;

score 4 · Accepted Answer · answered Feb 20 '14 at 07:35

4

select *
from all_tab_columns
where owner = 'SCOTT'

answered Feb 20 '14 at 07:35

score -1 · Answer 2 · edited Mar 12 '14 at 01:32

-1

This query should work:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS

edited Mar 12 '14 at 01:32

hichris123

answered Feb 20 '14 at 06:46

Sunil VM

Oracle does not have an `information_schema` – a_horse_with_no_name Feb 20 '14 at 07:35

2 Answers2