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.
Replace part of the email address: [email]kennedy-down_with_spammersattbi.com[/email]
with family. Remove the negative part, keep the minus sign. You can figure
"TsTom" <member22491dbforums.com> wrote in message
> Thanks for all input...
> Complete newbee here. Here is my version:
> Oracle8i Enterprise Edition Release 22.214.171.124.0 - Production
> PL/SQL Release 126.96.36.199.0 - Production
> CORE 188.8.131.52.0 Production
> TNS for HPUX: Version 184.108.40.206.0 - Production
> NLSRTL Version 220.127.116.11.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!
> Posted via [url]http://dbforums.com[/url]