Lesson learned today

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 now…

Please, hard-code your literals
A good entry-level interview question


  1. I think F5 needs a dialogue box for "Are you sure?"

  2. Connor McDonald
    12 March 2010 - 2:15 am

    serves you right for using a GUI…:-)

Leave a Reply

Your email address will not be published / Required fields are marked *