Just a little tip I picked up at the InSync13 conference from listening to Scott Wesley. If you have a lot of conditions that look like this:
(conditions based on a PL/SQL Expression, where the PL/SQL itself doesn’t actually call anything outside of Apex – it’s only dependent on variables (more...)
Am I the only one who finds this help message vaguely insulting?
Filed under: APEX
I heard part of the congressional hearing on the Obamacare debacle, and one commentator made the acidic remark “It was like watching people who could neither read nor write discuss a book.”
If your business does not understand the tradeoffs and complexities in your IT landscape, you need to (more...)
You didn't miss Part I
, at least not here you didn't.
Many of you know Mike Riley. If you don't, here's a little history. He's the past president of ODTUG (for like 37 years or something) and for the last two years, he's served as Conference Chair for Kscope. (more...)
Here is a way you might build a IT system: The users tell you what they want, and you build what they asked for. Sometimes you get it right, especially if you have good communication with end users and an iterative approach. Sometimes you get it wrong, especially if you (more...)
If you work with clients with in different timezones, be wary of the CURRENT_DATE/CURRENT_TIMESTAMP functions:
select (current_date - sysdate)
where dbtimezone <> sessiontimezone;
There’s posts timezone issues in more detail from Jonathan Lewis and Tony Hasler. For a quick example script, keep reading.
Manchmal stellt mich die Aufgabe der Wahl eines passenden Titels für einen Blog-Eintrag vor unlösbare Schwierigkeiten...
Vor knapp einem Monat hat Randolf Geist
einen Artikel mit dem deutlich griffigeren Titel View Data Volume Estimate
s veröffentlicht, den ich an dieser Stelle kurz zusammenfasse, um die Chance zu erhöhen, mich bei (more...)
Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!
where status = 'Enamoured';
with zohan as (
where state <> 'Tidy'
select * from zohan;
ODTUG board this week; I’m honored and excited to be joining such an amazing group of people to lead the Oracle Developer community through the technology world jungle.
I first became involved in ODTUG in 2011 when I started a campaign to get Oracle Forms sessions included in the KSCOPE (more...)
This year is kind of fun, my birthday is on November 12th (next Tuesday, if you want to send gifts). That means it will fall on 11/12/13. Even better perhaps, katezilla's
birthday is December 13th. 12/13/14. What does this have to do with SQL?
Someone mentioned to me last night (more...)
This week I did a little travel and went to Durham, North Carolina to present at the 2013 East Coast Oracle Users Conference (aka ECO). While I have been aware of this event for over 20 years, it is the first time I have attended. It was worth the trip. (more...)
I just needed some content from the Oracle Wiki. As a major enterprise software vendor, Oracle surely has a whole team managing their web presence – but apparently nobody is looking after their Wiki. It has more than a hundred content areas (called “spaces” in Oracle terminology), ranging from whole (more...)
Vor ein paar Wochen hat Jonathan Lewis eine Artikelserie begonnen, in der er erklärt, wie parallele Operationen durchgeführt werden und wie man parallele Pläne interpretieren kann:
- weist zunächst darauf hin, dass serielle Pläne in der Regel relativ harmlos bleiben und liefert ein paar Hinweise auf Fälle, (more...)
Earlier this month Oracle A-team member, Steven Davelaar released an in-depth article about the options that exist for going mobile with ADF. As this is one of my favorite topics I wanted to pass along the knowledge. I am going to give a quick summary of what the (more...)
I’m currently reading Writing on the Wall: Social Media – The First 2,000 Years
by Tom Standage. He draws the line from modern social media and the iPad back through history to roman times.
He makes the interesting point that modern one-to-many mass media is an aberration, and social media (more...)
One of the ongoing complaints about many data warehouse projects is that they take too long to delivery. This is one of the main reasons that many of us have tried to adopt methods and techniques (like SCRUM) from the agile software world to improve our ability to deliver data (more...)
A new iteration in the early adopter release cycle is available for download now.
I seem to get into a lot of conversations around Oracle Database Options lately. Of course the Database Options are great, no doubt about it. But people sometimes seem to forget what the word “option” means. There is a reason why Oracle doesn’t put everything into one big product but (more...)