Re: SQL statement to get all tables in the database

From: Harsha <harsha_at_rmatech.ca>
Date: 16 Nov 2004 09:24:55 -0800
Message-ID: <b0ce2d5d.0411160924.27c1cf2e@posting.google.com>

jrefactors_at_hotmail.com (Matt) wrote in message news:<ba8a039e.0411141914.53c314ff_at_posting.google.com>...
> In oracle, any SQL statements to get all tables in the database?
> I am using SQL* PLUS, and I want to see what are all tables in
> the database.
>
> Please advise. Thanks!!

Try using the following Sql query.

Select * from tab;

This will list all views and table in the schema.

Regards
Harsha Mogatala, M.Sc. Received on Tue Nov 16 2004 - 11:24:55 CST