Tag Archives: programming

TAG» , , , , , , ,

Oracle Tool: Populate Excel Sheets With Table Data

And another tool I use a lot.
I often get asked to export all the (relatively small) tables in a schema into worksheets in an excel workbook, one per tab.
Usually, theres a back and forth first with me trying to explain how this probably won’t mean much, the user
not understanding, me explaining, the user either not [...]

TAG» , , , , ,

Oracle Tool: Excel writes your sqlloader control file

Just a little geek moment here.
For my job, I do a lot of dataloads. Its actually kind of annoying because ctl files are kind of annoying.
ANYHOO, I got tired of writing the things and the typos and such, so I made a little VBA app in Excel.
The code assumes that the column names are [...]