Re: How to show the list of tables that I have access to.

In article <808581442.18515_at_gatekeeper.ebrd.com> Andy Smith <smith_at_ebrd.com> writes:

> select object_name from obj
> where object_type = 'TABLE'

Better yet, all_tables will show you all the tables you have access to.

--
 Alvin W. Law ........................................... Oracle Corporation
 Project Leader ............................. 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294

******************************** W a r n i n g ******************************
Microsoft Network is prohibited from redistributing this work in any form, in
whole or in part, without the express written consent of the original author.