News for hackers. Stuff that matters.

A comment on How I write SQL. Parent comment

Re:How I write SQL by jmelloy on Wednesday May 01, 2013 @02:10PM (#5639724)
I can't stand the XMLTable syntax. I like the idea of turning an xpath expression into a result set, but in practice it's a massive pain in the ass.
[ Parent | on HN ]
Re:How I write SQL by tom_b on Wednesday May 01, 2013 @02:22PM (#5639806)
XML and Oracle drives me crazy in general. You wind up with neither a relational model nor a generally useful way of data storage/exchange.

I am almost always working with legacy schemas, many generated by long-extinct tools or developers, and being a genuinely curious person, wandering down strange code paths to see if I can satisfy random reporting requests.

[ Parent | on HN ]