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:
 http://stackoverflow.com/questions/205736/oracle-get-list-of-all-tables