Oracle equiv of mysql show tables ?

[Betty]

Perhaps OT, but don't know where to post.

In MySQL we have "show databases" and "show tables"
What is the equivalent in Oracle if any?
Can I achieve the same result by doing a
select on one of the Oracle maintained tables?
TIA
Betty

 

[Ed Dana]

SELECT TABLE_NAME FROM TABS;

 

[Dimitri Maziuk]

Betty sez:

Perhaps OT, but don't know where to post.

In MySQL we have "show databases" and "show tables"
What is the equivalent in Oracle if any?

Oracle has no "databases". It has schemas that are usually
the same as user names.

Can I achieve the same result by doing a
select on one of the Oracle maintained tables?

Yes. Select from [SYS.]DBA_*, USER_*, and ALL_* views.
E.g. if your user/schema name is betty,
"SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='betty'"
or
"SELECT TABLE_NAME FROM USER_TABLES"
will give you the list of tables in "betty" schema.

"SELECT USERNAME FROM ALL_USERS" will give you the list of
users, hopefully your dba didn't do anything fancy and the
list is equvalent to "show databases" -- more or less: there
are a few system users in it, too.

You'll have to log in as dba to get to DBA_* views.

Dima

 

[Thomas Kellerer]

Perhaps OT, but don't know where to post.

In MySQL we have "show databases" and "show tables"
What is the equivalent in Oracle if any?
Can I achieve the same result by doing a
select on one of the Oracle maintained tables?

As you are doing this in Java I would recommend using DatabaseMetaData to
retrieve this kind of information:

<http://java.sun.com/j2se/1.4.2/docs...String, java.lang.String, java.lang.String[])>

Thomas

 

[Dimitri Maziuk]

Thomas Kellerer sez:

As you are doing this in Java I would recommend using DatabaseMetaData to
retrieve this kind of information:

Still won't work unless you know that on Oracle you need to
put getUsername() in schema parameter whereas on other engines
you need to specify catalog -- or nothing at all, depending.

Dima

 

[Richard Wheeldon]

Perhaps OT, but don't know where to post.
comp.databases.oracle.misc

In MySQL we have "show databases" and "show tables"
What is the equivalent in Oracle if any?

I don't know much about MySQL syntax, but probably
select * from dba_tables
or
select * from user_tables

Try looking at the Oracle complete reference:
http://www.amazon.co.uk/exec/obidos/ASIN/0072225211

Richard