Click here to Skip to main content
15,300,827 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 3:45
mvahoney the codewitch1-Nov-21 3:45 
GeneralRe: Bless SQL Pin
Jörgen Andersson1-Nov-21 5:36
professionalJörgen Andersson1-Nov-21 5:36 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 6:12
mvahoney the codewitch1-Nov-21 6:12 
GeneralRe: Bless SQL Pin
PIEBALDconsult31-Oct-21 15:17
professionalPIEBALDconsult31-Oct-21 15:17 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 16:30
mvahoney the codewitch31-Oct-21 16:30 
GeneralRe: Bless SQL Pin
PIEBALDconsult31-Oct-21 19:21
professionalPIEBALDconsult31-Oct-21 19:21 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 19:33
mvahoney the codewitch31-Oct-21 19:33 
GeneralRe: Bless SQL Pin
BryanFazekas1-Nov-21 1:50
MemberBryanFazekas1-Nov-21 1:50 
PIEBALDconsult wrote:
But you should do that up-front, before it hits the database.
True, we should. But in the real world, this doesn't necessarily happen. Like when dealing with a legacy Oracle system written in C++ (appears to be VS97 or VS6), where the DB design defies rational logic. Or any logic.

My queries have as many as 20 nested REGEXP_REPLACE statements to make sense out of the mess that some fields present. Ugly as sin, but it gets the job done. I'm counting the days until the replacement system goes online!
GeneralRe: Bless SQL Pin
Eddy Vluggen1-Nov-21 2:00
professionalEddy Vluggen1-Nov-21 2:00 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 3:41
mvahoney the codewitch1-Nov-21 3:41 
GeneralRe: Bless SQL Pin
Eddy Vluggen1-Nov-21 6:57
professionalEddy Vluggen1-Nov-21 6:57 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 7:02
mvahoney the codewitch1-Nov-21 7:02 
GeneralRe: Bless SQL Pin
#realJSOP1-Nov-21 2:41
mva#realJSOP1-Nov-21 2:41 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 3:42
mvahoney the codewitch1-Nov-21 3:42 
GeneralRe: Bless SQL Pin
Greg Utas31-Oct-21 15:36
mveGreg Utas31-Oct-21 15:36 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 16:31
mvahoney the codewitch31-Oct-21 16:31 
GeneralRe: Bless SQL Pin
Jon McKee31-Oct-21 15:41
professionalJon McKee31-Oct-21 15:41 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 16:33
mvahoney the codewitch31-Oct-21 16:33 
GeneralRe: Bless SQL Pin
NeverJustHere31-Oct-21 16:42
MemberNeverJustHere31-Oct-21 16:42 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 17:34
mvahoney the codewitch31-Oct-21 17:34 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 17:40
mvahoney the codewitch31-Oct-21 17:40 
GeneralRe: Bless SQL Pin
#realJSOP2-Nov-21 0:32
mva#realJSOP2-Nov-21 0:32 
GeneralRe: Bless SQL Pin
NeverJustHere2-Nov-21 17:58
MemberNeverJustHere2-Nov-21 17:58 
GeneralRe: Bless SQL Pin
#realJSOP2-Nov-21 23:55
mva#realJSOP2-Nov-21 23:55 
PraiseRe: Bless SQL Pin
Kornfeld Eliyahu Peter31-Oct-21 20:19
professionalKornfeld Eliyahu Peter31-Oct-21 20:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

On which operating systems are you writing code?
Let's see if things have changed since we last ran this. "writing code" meaning editing, building, and running the code on that OS.
  Results   495 votes