Here are some interesting Oracle PLSQL and SQL Blog Posts that we found during week 10 of 2013:
- Top 10 Tips & Tricks for Oracle SQL Developer
- Oracle Magazine
- 15 Things You Should Know about the ORDER BY Clause
- Oracle FAQ’s
- Morgan’s Library
By Jeff Smith
I’ve been sharing 1-3 tips or ‘tricks’ a week since I started blogging about SQL Developer, and I have more than enough content to write a book. But since I’m lazy, I’m just going to compile a list of my favorite ‘must know’ tips instead. I always have to leave out a few tips when I do my presentations, so now I can refer back to this list to make sure I’m not forgetting anything.
I have been receiving the Oracle Magazine for a while, and love it. I used to get it in printed format, but these days I receive it in an electronic format, for online reading. If you do not already subscribe to Oracle Magazine, I would definitely suggest that you check it out. It has a lot of news about Oracle. And, Steven Feuerstein usually have an awesome section on PL/SQL. Lately he has been speaking about PL/SQL Cursors.
When multiple columns/expressions are specified in the ORDER BY clause, the precedence of sorting is left to right.
The ORDER BY clause can order in ascending (ASC) or descending (DESC) sequence, or a mix of both. If ASC or DESC is not explicitly stated, then ASC is the default.
By Oracle FAQ
The Oracle FAQ is NOT an official Oracle Support site, but rather a get-together of people with jobs in Oracle. In our spare time we come together here to learn about Oracle, share knowledge and try to help others solve their problems. In doing so, this sites puts a wealth of information at the fingertips of Oracle professionals all over the world. You can use our directories and powerful search facilities to quickly locate all the information you need. …
The library is a spam-free on-line resource with code demos for DBAs and Developers.
If you would like to see Oracle database funtionality added to the library … just email us.
Coming soon … Oracle’s Database 12cR1. While waiting: check the section of ODA’s and ZFS.