Re: Other commands instead of "show tables"?

From: eugenep <eugene_at_mail.gsfc.state.ga.us>
Date: 23 Oct 2003 07:18:47 -0700
Message-ID: <f57221ec.0310230618.19728687@posting.google.com>

Curt:

SHOW displays the value of a "feature" of SET (SET turns a SQL*Plus feature ON or OFF or to a certain value). TABLE is NOT a valid SET or SHOW feature. Once connected to your data base see if the following command will work:

select table_name from user_tables ;

The result set will show all the tables created in your schema (schema = the usercode you used to connect to the data base). Hope this helps.

Regards,

Eugene Pokopac (Oracle DBA - Tucker GA) Received on Thu Oct 23 2003 - 09:18:47 CDT