At work, we are currently using Oracle Discoverer.
My question is, if Toad is web based or .exe. based. If Toad is .exe based can it be executed in a .bat file and
fed the query name and ask it to export the results to excel file as i can do with Oracle discoverer as described below.
Oracle Discoverer comes in 2 flavors: web based and desktop based (.exe).
The adv. of .exe is i can call the query using a .bat file like this:
Please note that whenever you see XXX_, that is a variable that i replace in vba with a meaningful value.
C:\oracle\BIToolsHome_1\bin\dis51usr.exe /connect XXX_SignOn/XXX_Password@odsp8 /opendb "SREG.Advisor_CAD_M3enrolled_M4unenrolled_forPostingOnBullentinBoard" /sheet ALL /parameter Parm_AcademicPeriod xxx_parm1 /export XLS xxx_ExcelFile /batch