Re: show me the tables

try 'select table_name from user_tables;'

In article <95tsh0$c48$1_at_nnrp1.deja.com>,   ckaandrp_at_my-deja.com wrote:
> I have a connection with a non-local Oracle database, made by a java
> program. I usually worked with mySQL and if I had established a
> connection with a database, I could get all the tablenames with a
 simple
> mySQL-query: "show tables". So now I want to do the same thing in
> Oracle, but I cant find a similar query. Is there some command in
 Oracle
> which enables me to get all the table names?
>
> thanks in advance
>
> Casper
>
> Sent via Deja.com
> http://www.deja.com/
>

--
Back it up !


Sent via Deja.com
http://www.deja.com/