Re: Newbie - How can I list all the tables in a schema?

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/12/06
Message-ID: <58a66g$5pl_at_newton.pacific.net.sg>#1/1


earvin_at_omega.uta.edu (Earvin C. Lim) wrote:
>
>How can I list all the tables in a schema?
>Thanks!
>
>--
>Earvin Lim

Hi there,

Issue the following statement under the schema

SELECT TABLE_NAME
FROM USER_TABLES Regards

N.Prabhakar Received on Fri Dec 06 1996 - 00:00:00 CET

Original text of this message