list of all tables

From: Jake Battle <jbattl_at_sapient.com>
Date: Wed, 19 Aug 1998 12:38:18 -0400
Message-ID: <0685A427A719D11197BB00A024D399450796D6E5_at_delphi.sapient.com>


You can also do:

select * from dictionary

I think this gives you some extra system tables & views

> -----Original Message-----
> From: twang_at_visa.com [SMTP:twang_at_visa.com]
> Posted At: Monday, August 17, 1998 7:10 PM
> Posted To: tools
> Conversation: list of all tables
> Subject: list of all tables
>
> Hi all,
>
> I just start to use the SQL* PLUS. I got a question, how can I get a
> list of
> all tables. The describe command can diaplay the column of a table,
> but I
> first I have to know the table name. where and how can I get all the
> table
> names??
>
> Thank you!
>
> Tong Wang
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member
> Forum
Received on Wed Aug 19 1998 - 18:38:18 CEST

Original text of this message