RE: Oracle 10g SQL - Parsing Delimited String
"Bryan, Timothy" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hmmm, What about unit testing, which allows re-run when subtle changes are required. Best Regards Timothy Bryan We are what we repeatedly do. Excellence, therefore, is not an act but a habit. Aristotle From: [email protected] [mailto:[email protected]] On Behalf Of Simoneau, Roger Sent: Monday, January 16, 2012 11:03 AM To: '[email protected]' Subject: RE: [toad] Oracle 10g SQL - Parsing Delimited String >> Nate served it out to me in a golden platter Well… that depends :) It might only be a silver platter depending on what happens next. If a subtle bug shows up, will you be able to debug and solve it? Sometimes it’s better to go with a not-quite-so-elegant solution in order to resolve any issues later… or even make changes to it. I am totally green on regular expressions so I don’t know if Nate’s solution is perfect or if it’ll choke on some special character in a different data format – like French characters. How about if a change is required and the business rules want a second character ignored in the selection? Ultimately, it’s up to you to test the solution against the data you’re providing the solution for. A developer should always know what will happen to his code when any value is passed in to it. Either the value is expected and handled properly, or the value is invalid and should be trapped in an appropriate exception mechanism. Roger S. ________________________________ This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply. ---------------------------------------------------------------------- Waste Management recycles enough paper every year to save 41 million trees. Please recycle any printed emails.