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!
Working with some Oracle Constraints
I was working with some code and wanted to add a Check Constraint for my test database. Using Oracle 10g I looked up some syntax reference and lo and behold I found Regular Expressions staring right at me! Quick side note : Coming from a programmers point of view I have to say the Oracle's Database is the most powerful and flexible database I have ever dealt with. You can write ANSI SQL, Oracle flavor SQL, and PL/SQL (not counting using Java for procedure language too). Also, every modern programming language works against it! Heck go to http://www.monster.com and search on Oracle - you'll get OVER 1000 postings. Its a great database and their is a REAL shortage of professionals who can work with it. Anyway, back to my simple constraint. Like I said earlier, Oracle does something I like - they support Regular Expressions in their SQL. Regular Expressions basically allow you to pattern match data to determine if it is what you are looking for for validation, etc. If yo...
Comments