Re: newbie: dumb question
From: Mark Woytus <mwoytus_at_divcomp.com>
Date: Fri, 05 Jun 1998 03:13:54 GMT
Message-ID: <35775eeb.15738377_at_news.dave-world.net>
Date: Fri, 05 Jun 1998 03:13:54 GMT
Message-ID: <35775eeb.15738377_at_news.dave-world.net>
On 4 Jun 1998 23:19:17 GMT, nasand00_at_sac.uky.edu (Nathaniel Sanders) wrote:
<snip>
> How can I get a list of all table names?
<snip>
Query the data dictionary.
"select table_name from all_tables;" will list all tables you have
access to. Hint: try "describe all_tables" and perhaps "describe
all_tab_columns" and see what you get.
Mark Woytus (w)309.888.8423 (f)309.888.8246
Diversified Computer Consultants
mwoytus_at_divcomp.com woytus_at_acm.org
Received on Fri Jun 05 1998 - 05:13:54 CEST