Well, the project from hell is finally winding down. We've done a tremendous amount of code in just a few short(but felt very long!) weeks. I know more C++ now than ever - and actually gotten use to coding in C++. The only thing I come to realize is Microsoft's Visual C++ compiler leaves a lot to be desired. Anyone who has done a large project (well over 20K lines of code) in C++ is probably well to familiar with the requirement to clean before every compile and after a few hours, you have to delete the obj folder because it just won't clean anymore. Of course a daily reboot is required too. With .NET I'd have to reboot about once a month!!!
Of course, we just heard the vendor is changing the product platform from Windows CE to Linux in the next firmware version, so I am looking forward to getting to use GNU gcc compiler!
Oh well, hopefully things will get back to normal this week and I can actually spend sometime at home doing all the things I've been neglecting!
Oracle External Table
I am always being asked to get some data into a database. Most of the time it is just a matter of writing an import or using a bulk import tool to load the data. However, sometimes it’s a little more complicated than that. Well, I have been working with Oracle 10g database lately and love the external table feature. Oracle external tables is a wonderful mechanism that allows you to take an CSV or fixed-length file and logically map it as a database table. The advantage of this over import is a lot of times you have external data that you want to “load” for reporting and scrubbing against, but once the data has been scrubbed, it is useless. This is especially useful where business demands require you to take external data and check against your system. I could have really used this feature when I wrote a process to verify telephone number porting reports. Local Number Portability (LNP) and Wireless Number Portability (WNP) required us to verify “owner” of a number and make sure we turn ...
Comments