INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Get Oracle Tablenames

Get Oracle Tablenames

(OP)
I am using VB 6 front end and Oracle 10g back end.
I need to look through each table to see if a id (selected on a form) exists in that table.    For each table that has the key(id), I need to load the tablename into a combo box.  

There are approx 200 tables and I do not have the slighest idea of how to code for this. Does anyone have any code snippets or suggestions to help accomplish this?
Thanks
Lhuffst

RE: Get Oracle Tablenames

To get a list of tables from Oracle, there must be some methods.

I think one would be to use the .OpenSchema method of an ADO Connection. Here's some info.

http://msdn.microsoft.com/en-us/library/ms945095.aspx
http://www.w3schools.com/ado/met_conn_openschema.asp

OpenSchema would return a recordset, containing the information requested. Starting with the adSchemaTables, which should be supported by all providers, you have your list of tables and views, then you may proceed with opening each table, check for existance of field, then value(s).

Then, there must also be ways of enquiring the system tables of oracle, here is one thread with both OpenSchema and ALL_tables
http://www.codeguru.com/forum/showthread.php?t=193758

Roy-Vidar

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close