Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: view all tables in database

Re: view all tables in database

From: <ihs_at_cyber.net.pk>
Date: 1998/03/19
Message-ID: <6eqq5b$aeg$1@nnrp1.dejanews.com>#1/1

Hi,
Please login in system account or any privilege account in sqlplus and do the following

select table_name from all_tables;
Regards
Irfan

In article <6eqahi$du95_at_id4.nus.edu.sg>,   spadesmania rules <jeremybi_at_iscs.nus.edu.sg> wrote:
>
> how do i view the list of all the tables that I created in Oracle ?
> what is the command in sql*plus ? thanks.
>
> --
>
> spadesmania rules
>
> >>>> http://www.iscs.nus.sg/~jeremybi <<<<
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US