Re: get tablenames

On Fri, 12 Apr 2002, i7lema_at_rz.uni-jena.de wrote:
> Hi,
>
> I need a sql-query to get all tablenames of a scheme

select table_name from user_tables.

> or user in a database.

select username from all_users.

> select * from tables; in mysql it's "showtables".
>
> It would be nice if You had a URL or a how-to to get tips for
> such queries like that in my question.

There are boatloads.

Here is a url to satisfy your above needs and needs like it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/toc.htm

Search all the online documentation for anything. http://tahiti.oracle.com/pls/tahiti/tahiti.homepage

There are just sooooo many more. Try spending some time on google, especially this group.
http://groups.google.com/groups?hl=en&lr=&safe=off&group=comp.databases.oracle.server

And lastly, always consult everybody's favorite and a regular on this group, Tom Kyte.
http://asktom.oracle.com/pls/ask/f?p=4950:7:53637::NO:::

If desperate, here's a url I have. Notice, I haven't updated it in awhile and I ain't no great html'r, but I reference it alot. I've organized the world in how I view it. (I authored it in a few weeks as I was consulting the tahiti site I sent you) http://www.geocities.com/galendboyer/oracle/index.html

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.