Get Database's Tables

I want to write a query to get the names of tables of a specific databa开发者_JAVA技巧se, but I don't know how can write it.

I want to execute this query for MS Access 2007 and Oracle 11g.

Thanks

If you want raw, direct queries:

For Oracle:

SELECT * FROM user_tables

For MS Access:

SELECT * FROM  MSysObjects  WHERE [Type] In (1, 4, 6)

(sorting and advanced filtering omitted for brevity.)