24 February 2012

How to select name of all tables from oracle database ?

To get list  of name of tables in yoru database (as current user) run below script:

SELECT table_name
FROM user_tables

It will works if you have granted access to do that.

Useful resource for additional info can be found here: