VBA//Oracle Interfacing Question

J

jason

All,

I have been able to correct to my database but I have one question
question:

Within objSession I want to list all available tables and all
available views.
How exactly is this done?

thank you.

Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
 
J

jason

All,

I have been able to correct to my database but I have one question
question:

Within objSession I want to list all available tables and all
available views.
How exactly is this done?

thank you.

Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
Click to expand...


figured it out quick and dirty:
Sql = "SELECT table_name FROM user_tables"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find in Oracle 9
OO4O execute a query against Oracle, VBA Excel 2003 5
Any Replacement for CDO and MAPI ? 6
Determine OL sender w/o opening message? 3
Using c# object in Excel VBA 5
Matching Addressbook Recipients to Contacts 1
Referencing other Office programs in a Excel VBA App 2
Possible to pass a variable to Excel from command line/short cut? 2

Top