Re: Get all table names in a database

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Fri, 14 Jan 2000 14:21:22 GMT
Message-ID: <85nbck$t1u$1@nnrp1.deja.com>

Yes,

My SQLPlusPlus also provides a convenient way to gets lists of tables (and other objects) for any user with simple commands from SQLPlus.

e.g.

SQL> EXEC S.LSTTAB('%','SCOTT') will list all tables for scott.

SQL> EXEC S.LSTTAB('%','%') will list all tables for all the users

SQL> EXEC S.LSTICL('%','SCOTT') will list all indexes (with index columns) for all tables in SCOTT schema.

regards,
M. Armaghan Saqib

---

SQL PlusPlus - Add power to command line of SQL Plus SQL Link for XL - Integrate Oracle with XL Download free:
http://www.geocities.com/armaghan/

---

In article <947850427.29362.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> Sorry to contradict you.
> All_tables shows all the tables the current use has access to/
privilege on.
> dba_tables shows ALL tables in the database.
>
> Best regards,
>
> --
> Sybrand Bakker, Oracle DBA
> Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message
> news:387ea3ad.12965713_at_172.16.7.5...
> > On Thu, 13 Jan 2000 20:36:59 -0500, "Legend" <legend_at_spacelab.net>
wrote:
> >
> > select owner,table_name from all_tables;
> >
> >
> > >Hello all,
> > >
> > >How would I get all the table names available in a database within
> sqlplus a
> > >session?
> > >
> > >regards,
> > >
> > >benny

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 14 2000 - 08:21:22 CST