Re: show me the tables

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Sun, 11 Feb 2001 08:11:43 +0200
Message-ID: <3A862D1F.279CF2CF@intersystemsww.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/

Hi Casper,
If you're using java (specifically JDBC - I imagine) to access the Oracle database, then use the 'getTables' method in class java.sql.DatabaseMetaData

HTH,
Avi. Received on Sun Feb 11 2001 - 00:11:43 CST