Re: view all tables in database

 Select object_name from user_objects where object_type = 'TABLE';

On 19 Mar 1998 05:30:26 GMT, spadesmania rules <jeremybi_at_iscs.nus.edu.sg> wrote:

>how do i view the list of all the tables that I created in Oracle ?
>what is the command in sql*plus ? thanks.

Good Luck! Brian_RestonVA Received on Fri Mar 20 1998 - 00:00:00 CST