I hate to say it, but you are most definately a Weasel.

In my time as a DBA, I learned that if I wanted to keep my databases clean and running well, I had to keep a good relationship with the development teams. Often that lead to a lot of dumb questions, but sometimes I got the opportunity to make the database better and teach the developers a few things about how you should be programming with a database.

Now, in this case, I would have asked a few more probing questions, like "Is a value of ' ' invalid everywhere?" or "Have you tried rtrim()?" I would have also checked the original specifications for the control files or the input data files.

What you did will keep the developers from coming to you when they have questions, and more importantly, design questions. Now, in six months when you have to look into why new tables in your system are blowing out extents or help developers with why queries are so slow in your production databases, you can look at this episode here for the reason why.

In reply to Re: (OT) Am I weasel or just right? by Steve_p
in thread (OT) Am I weasel or just right? by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.