Looking for Opinions: Do you create fancy Excel spreadsheets using Oracle data?
Posted on 2010-01-12
I have more of a Microsoft Access/Excel VBA background, and am now in an Oracle environment.
My user would like me to populate a fancy Excel spreadsheet using Oracle data.
I was wondering your processing technique:
a) Do you code pl/sql to get the data, write a temp table, and then use the temp table to
populate the spreadsheet?
b) i have gaps in my computer knowledge. i aware that there are other scripting languages.
Do you combine pl/sql script with other scripts to create a batch flow that creates the
c) do you schedule this script or run manually?
i am trying to understand what common practices are, so that i am somewhat in compliance
with techniques, and therefore will understand what skills i need to learn to accomplish this.