How can i export the results of an Oracle query (oracleXe with Apex) to a javascript or vbscript array ?

Question

i am using oracleXe with apex. I want to export the results of a query to excel while retaining formatting. This is possible if i export the results of the query to a javascript or vbscript array and use activex to export the results to excel.

Answer 1

You don't need to go through all that.



Using Oravle Objects for OLE, you can push your data directly into an Excel spreadsheet.



Alternatively, you could do it the hard way with Odbc.

Answer 2

You can make JAVA read the query results and create a .cvs file with the results. You might need JAVA to separate these query results with a comma so that it is in cvs format.



Then when it creates the cvs file, you can open it with excel and excel has the ability to parse the cvs file and it will display the results.



then just format the excel file the way you want and save it as an excel form.



EDIT: This is how I use JAVA to do it, I dont know if you can use the same method using VB. This is just an idea of what you can do.

Answer 3

you're stunning, nutrition "chains" are certainly nutrition webs, with predator/prey interactions among and between stages. Apex predators do exist in organic structures nonetheless. In India and areas of Asia as an occasion, tigers are (or have been) on the precise of the nutrition cyber web. interior the oceans (reckoning on the geographical area) the two orca or super white sharks occupy the apex predator place. EDIT: As Skookum suggested, creation of an unique predator into an environment can "create" an apex predator. right here in New Zealand as an occasion we haven't any community mammalian predators. The creation of stoats, cats and canine as we communicate located those species on the precise of community nutrition webs. EDIT lower back: sounds like there's somewhat bewilderment around the definition of "predator". A predator is an animal which hunts and kills yet another animal for nutrition. The operative words indexed under are "kill" and "nutrition". Viruses and micro organism are pathogens, no longer predators: those use hosts to replica their genetic fabric, no longer for nutrition (and in maximum situations do no longer kill the host). Parasites (leeches, mosquitos etc) do feed on their hosts yet ideally do no longer kill them. the occasion of the dolphins torpedoing the shark is protective behaviour to guard the pod: they had no purpose of eating the shark and have been maximum possibly attempting tocontinual it off extremely than relatively attempting to kill it. it is not predation.