Lesson learned today

Jeffrey Kemp | Mar 10, 2010 23:35 +0000
Comment out all "DROP TABLE" commands in my scripts.(I accidentally hit F5 when the focus was in the wrong window - which happened to contain a "DROP TABLE / CREATE TABLE" script - my Toad session goes and happily drops the table that I'd been gradually accumulating statistics into for the past 3 days - and no, there's no flashback table in 9i)At least I kept all my scripts - rerunning them all

Please, hard-code your literals

As Feuerstein says,We all know that hard-coding is a bad thing in software. But most developers think of hard-coding simply as typing a literal value into your program whenever you need it....So what's wrong with doing this? Nothing - as long as the value is never going to change. But what's the chance of that happening? In fact, what's the chance of anything staying the same (never changing) in