Re: How to show the list of tables that I have

From: Randy Dewoolfson <randyd_at_cais.com>
Date: 1995/09/04
Message-ID: <42fk2l$9hh_at_zippy.cais.net>#1/1


Andrea Dehling (dehling_at_h01x.nbg.scn.de) wrote:
: In article qpg_at_ringer.cs.utsa.edu, sli_at_runner (Sijian Li) writes:
: >
: > Hi Folks,
: >
: > I am in the situation that I forget the name of tables I have created, how can
: > I get a list of the tables I have?
: >
: > Thanks.
: >
: >
:
:
: use the following select statement:
: select table_name from user_tables;
:
: Andrea
: ---
:

TRY
SELECT * FROM TAB;
or for fanciness
SELECT * FROM ALL_CATALOG;
+ many more....

-- 
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I
Received on Mon Sep 04 1995 - 00:00:00 CEST

Original text of this message