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
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===IReceived on Mon Sep 04 1995 - 00:00:00 CEST