Re: [Q] How to list all the tables in DB??

In article <4m3c3q$j8a_at_news2.cais.com>, MCC <duffy_at_cais.cais.com> wrote:
>We have Oacle 7.2.3 installed on SUN Solaris 2.5. Can anyone tell me how
>to list all the tables in DB? the list should include table name,
>tablespace name, owner info. Thank you for help.

I login to sqlplus and type:

        select distinct table_name from cols;

The Oracle Reference Manual has documentation on the database catalog in full detail. I tend to use the following to see table structure:

	select column_name, data_type, data_length, nullable from cols
		where table_name = 'foobar';

These two make handy stored procedures.

/charles Received on Fri May 03 1996 - 00:00:00 CEST