Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting list of available tables
You want to query the system catalogs. For a list of all tables You can see
it would be
select table_name from all_tables;
for a list of all tables you own it would be
select table_name from user_tables;
for a list of all tables (assuming you are the dba)
select table_name from dba_tables;
Go to otn.oracle.com, sign up for free and you can download software, read
the on line manuals.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "TsTom" <member22491_at_dbforums.com> wrote in message news:2384242.1042510128_at_dbforums.com...Received on Mon Jan 13 2003 - 21:21:13 CST
>
> Thanks for all input...
>
> Complete newbee here. Here is my version:
>
> Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
> PL/SQL Release 8.1.7.2.0 - Production
> CORE 8.1.7.0.0 Production
> TNS for HPUX: Version 8.1.7.2.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> I access all of my data using VB through a terminal emulator.
> WRQ's Reflection for Regis Graphics. The data is read off the screen,
> cleaned up, and then saved as text files. I would really like to access
> the database directly. I am able to use SQL Plus through the above
> mentioned terminal emulator. Is there a way to gather a list of
> available tables and stored procedures? Or, would I need foreknowledge
> of the names of each. Also, can you direct me to any sources which
> might give me the information I need to connect to the Oracle database
> directly from Visual Basic. My ultimate goal would be to query the
> database directly using ADO.
>
> Thank you very much for any help you can offer!
>
> Tom
>
> --
> Posted via http://dbforums.com