Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Question: How to Select All User Created Tables?
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