From: jason on
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)
From: jason on
On Nov 16, 12:05 pm, jason <jason.mell...(a)gmail.com> wrote:
> 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)


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