When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you need the documentation for? Just open google and search”. Even though googling stuff usually works, I actually like the documentation (in some aspects at least).
I ran into this post on Linkedin talking about what non-Israeli people should expect when working with Israelis (and especially if they visit Israel for business). It’s a very nice read and it’s not long. After reading it (and laughing to myself, as it’s quite accurate), I decided to write this post. Most of the people that read my blog are spread around the world, and the culture difference between countries is truly interesting.
Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right!
Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
I’m downloading it as I write, and hopefully will have time to play with it a little bit soon. I wrote so much about new features that I have to try some of them at least. Stay tuned!
A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know.
When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes.