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: Simple Question: How to Select All User Created Tables?

Re: Simple Question: How to Select All User Created Tables?

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Thu, 23 Aug 2007 22:27:31 +0200
Message-ID: <5j68tiF3qoj71U1@mid.individual.net>

Stuart wrote on 23.08.2007 22:14:
> Hi,
>
> I'm fairly new to Oracle and I was wondering if there was a simple way
> to return a list of all user created tables (with no system
> tables)..

SELECT * FROM USER_TABLES More details in the chapter "Static Data Dictionary Views" of the manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_part.htm

Thoams Received on Thu Aug 23 2007 - 15:27:31 CDT

Original text of this message

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