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"
 
Top