Re: Basic SQL Command
From: Chris Rizzo <abcd_at_efgh.com>
Date: Tue, 30 Jan 2001 12:38:32 -0500
Message-ID: <et7jCMuiAHA.278_at_cpmsnbbsa07>
Date: Tue, 30 Jan 2001 12:38:32 -0500
Message-ID: <et7jCMuiAHA.278_at_cpmsnbbsa07>
At the SQLPlus prompt:
SELECT table_name FROM user_tables
will give you all the user created tables in the database. For additional information, you can issue
DESC user_tables
from the SQLPlus prompt too...
HTH
HTH
"Nicolas Boseret" <nicolas.boseret_at_be.origin-it.com> wrote in message
news:0E16861EE7BCD111BE9400805FE6841F1429DBE9_at_c1s5x001.cor.srvfarm.origin-it
.com...
> Hi there,
> could anybody tell me what are the basic command in SQL to find what are
the
> DB available and what are the tables in it ...
>
>
> Many thanks,
>
> Nicolas.
>
>
Received on Tue Jan 30 2001 - 18:38:32 CET