Interesting Things You May Have Missed Today
- Common Errors in English Usage
- Popular myths in software development
- Video and text tutorials for a variety of computer related topics
- REST Vs SOAP web services
- Interactive web based Vim tutorial
- Overview of the Oracle NoSQL Database
- Listening to Mozart Won’t Make You Smarter
- The Most Exciting Oracle OpenWorld and JavaOne Announcements all in One Place
Why You Must Use an ORDER BY Sometimes
Suresh submitted this question on the Oracle Community forum:
in oracle 10 g , the below query results in alphabetical order , there is no order by caluse. but when i am running the same query in oracle 11g , it gives me in random order. what is the problem here?
People, it is really simple: You want an ordered result set? use ORDER BY.
Tom Kyte wrote about it in this blog post and in his books:
Do not ever count on the order of rows from a query unless you have an ORDER BY statement on your query!
The only way to retrieve data from the database in some sorted order is to include an ORDER BY on your query. There is no substitute for ORDER BY.
By the way, the query in the forum post looks suspiciously Hibernated. Don’t let Jeff know 
Five Recently Created or Updated Oracle Support Articles
- Master Note: Database Performance Overview
- FAQ: Database Performance Frequently Asked Questions
- New Parameter DB_ULTRA_SAFE introduced in 11g
- How To Get Access To Help- Examine – Custom Code- Personalizations in R12.1.3
- Russia abandons DST in 2011 – Impact on Oracle RDBMS
Women as Programmers
Yolande wrote:
The lack of women in programming is in part a cultural issue that differs from region to region. In developed countries, very few women work as programmers whereas in Brazil and India a lot of women pursue careers in IT. Women in developed countries perceive the field as isolating and very few young women graduate in computer science. This perception of isolation was based in reality decades ago, but that is no longer the case today.
Well, you may be surprised to learn that the earliest computer programmers were women and that the programming field was once stereotyped as female.
Leave a comment | Filed in Technology | Tags: gender, programmingWhat is the Oracle Learning Library?
It’s a really useful resource. The Oracle Learning Library allows you to search for free online learning content on the internet. The content comes from a variety of sources, including OTN, YouTube and Blogs.
Leave a comment | Filed in Links, Oracle, Tips | Tags: video
