Wednesday, March 31, 2010

Quirky Oracle

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.

No comments:

Post a Comment