So I was working today and I ran into a quirk in Oracle. My error went along the lines that my right parenthesis was missing. When 2 or more queries Union, Oracle doesn't like the order by inside the query. Therefore I had to do it outside of the query. Crazy right! That was so random! Things like this happen in real life some times.
Earlier in the day I feel I made a mends to a problem with a co-worker that was not created by me but just investigating it a bit I was able to get a resolution. Not everything is obvious at first but sometimes resolutions can be achieved with some effort. It's a good lesson because giving up and just accepting the situation doesn't teach anyone anything.
Showing posts with label missing right parenthesis. Show all posts
Showing posts with label missing right parenthesis. Show all posts
Wednesday, March 31, 2010
Subscribe to:
Posts (Atom)
