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

OO4O execute a query against Oracle, VBA Excel 2003 5
Find in Oracle 9
filling sheets with Oracle ???? 0
How to find record in Oracle 0
Using VBA to change Crystal Reports settings from Oracle to SQL 0
Problem with SET & REF function 0
Need help modifying code 0
Any Replacement for CDO and MAPI ? 6

Top