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.
Comments Off | 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.
Comments Off | Filed in Links, Oracle, Tips | Tags: videoUsing Web Services in Oracle Application Express [video]
Have you utilized SOAP or RESTful Web Services in your Oracle Application Express application? If not, Marcie Young, consulting curriculum developer at Oracle, shows you how. It’s easy and all wizard driven [Docs].
In the following three screencasts, Marcie goes through the steps to create and use a manual SOAP Web Service reference as well as a RESTful Web Service reference with and without a bind variable.
2 Comments | Filed in Oracle | Tags: apex, video, webserviceOracle Public Cloud, It’s Here
More information at cloud.oracle.com.
Comments Off | Filed in Oracle | Tags: cloud, oow11Oracle ACE Director Product Briefing
Last Thursday and Friday, I, and my fellow ACE Directors, attended a product briefing at Oracle HQ. Essentially, it was a mini conference for ACE Directors organized by the ACE program team.
During these two days, Oracle product managers and SVP across different product lines shared with us the latest and greatest and what’s going to be announced next week in the areas of database, middleware and development tools.
1 Comment | Filed in Oracle | Tags: aced, oow11Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
A BLOB data type stores unstructured binary large objects. A table column with a BLOB data type can be used to store all types of files such a documents, spreadsheets, images and plain text. You can manage BLOB columns by easily adding file upload and download functionality to a form you create using Oracle Application Express (APEX).
APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
The following is a screencast to demonstrate:
- how to create a simple APEX application to store the content of any file into a BLOB column and
- how to save the content of that BLOB into a file on the database server.
I recorded the screencast on Windows 7 and Oracle APEX 4.0 that comes pre-installed with Oracle Database Express Edition 11g Release 2.
But first, here is the code that I used in the screencast:
Comments Off | Filed in Oracle | Tags: apex, howto, videoHandy Oracle Scheduler Troubleshooting Tip
This is a guest post by David Clement, a veteran database engineer and a friend of mine. You can find him online at davidclement.org.
I’ve found the following query handy for investigating an ORA-12012 in an alert log. ORA-12012 is a dbms_scheduler execution error and it provides a job number without a name, where the Scheduler views give job names without numbers. So, to relate the job number to a name:
SELECT d.job_name, d.job_action
FROM dba_scheduler_jobs d JOIN sys.scheduler$_job s
ON d.job_action = s.program_action
WHERE s.obj# = &job_number;
Maybe this will be useful for others as well.
Comments Off | Filed in Oracle, Tips | Tags: dbms_scheduler
