ExcelBanter - VBA//Oracle Interfacing Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA//Oracle Interfacing Question (https://www.excelbanter.com/excel-programming/436239-vba-oracle-interfacing-question.html)

jason

VBA//Oracle Interfacing Question

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)

jason

VBA//Oracle Interfacing Question

On Nov 16, 12:05*pm, jason 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"

All times are GMT +1. The time now is 04:41 AM.