The questions in the quiz were, of course, all trick questions.
Question 1: Answer D
SELECT * FROM T1 LEFT NATURAL JOIN T2;
SELECT * FROM T1 NATURAL LEFT JOIN T2;
The second example shows the correct syntax for a natural outer join. In the first example, LEFT is interpreted as a table alias for T1 and so an inner join is used.
QUESTION 2: Answer E
SELECT * FROM T1 INNER JOIN T2 ON (more...)
Dec. 2, 2014 marked the first ODTUG Oracle Mobile Day, hosted at Oracle Headquarters in Reston, VA. This is a format we hope to replicate in different cities across the US and in Europe in the future. We were really excited to have with us Suhas Uliyar, Oracle’s VP of Mobile Strategy and Product Management, and the visionary behind Oracle mobility. I had the honor of introducing him to (more...)
Learning, relearning or unforgetting…
What value is there in a DISABLEd constraint?
This was a question on the OTN forums this week and a) my first reply was wrong and b) I couldn’t find a clear demonstration elsewhere.
The ETL process commonly verifies that certain constraints are true. For example, it can validate all of the foreign keys in the data coming into the fact table. This means that (more...)
We have a reporting application that does just this; and the query also links to an authorisation table that decides what types of users see which reports.
You can create a snapshot (materialized view) using something as simple as
create materialized view apx_application_pages
At Kscope14 ODTUG had a “Social Media Lounge” where they interviewed leaders and visionaries in various technology fields. They have just released a great one where John King, a renowned Oracle ACE Director for middleware and Oracle development tools, interviewed Michael Ferrante, the Oracle Forms Product Manager. Of course the hot topic was the future of Forms. When asked about this Michael responded:
“I’m smiling because I hear that [Forms is dead] a lot as well. I (more...)
If you are an attendee of UKOUG Tech14 you have a chance to win a free copy of Troubleshooting Oracle Performance (2nd edition) by Christian Antognini
Troubleshooting Oracle Performance, 2nd Edition provides a systematic approach to addressing the underlying causes of poor database application performance.
AND a you can also win a free copy of Expert Oracle SQL by Tony Hasler
Expert Oracle SQL provides a systematic approach for tuning individual SQL (more...)
Last week I did a quick hop, skip, and a jump across the pond to Nuremberg, Germany for the DOAG usergroup conference. Although I was only there for a total of 54 hours, I’m so glad I made the effort to attend. I was especially honored to go to represent ODTUG as we further attempt to increase cooperation and connect with fellow user groups around the world.
I have Tom Kyte’s “Ask Tom” in my feed reader, and every now and then it opens for questions and the flood pours in. Quite often there is an interesting question, but more often than not there are quite a lot of “poor” questions: some just poorly worded, some too-easily-googleable, others are could-have-answered-from-the-docs questions. It’s not dissimilar to StackOverflow, which doesn’t suffer so much because of the army of people who work together to either improve or (more...)
Every now and then you come across a feature or a combination of features which has turned into such a dog’s dinner that you wonder how many people can possibly be using it.
This week – fast fresh materialized views.
I would have thought that this was a very commonly used feature.
This is quite a long article so I will do a top-level TOC first
Apparently this was upgraded earlier in the year and it's a shame I didn't have this a year ago!
|Chrome Developer Tools Mobile Emulation|
- Specify the device you'd like to emulate from a decent range of contemporary devices
- This viewport can then be easily scaled to suit whatever monitor (more...)