Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: view all tables in database
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