Tag Archives: database

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 [...]

Databases: why its bad to only know a little

I’ve just started a new job and I’m working as half-dba-half-developer (it is supposed to be mostly development, but I can’t see how thats going to happen).  The product I’m supporting (3rd party product) is very obviously written by people who don’t know much about databases.
1. Instead of passing in data from the front end [...]