Comparing Schemas: Red Gate Schema Compare for Oracle

Alex Nuijten on 26 January 2012 with 0 comments

This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use Tools” and was focussed on, well, tools. At the end of Cary’s talk, James Murtagh showed a demo of their Schema Compare tool. The demo wasn’t flawless, but he recovered nicely (note to self: don’t do live demo’s). And this… Continue Reading →

APEX: Friendlier Exception Message from AJAX Call

Alex Nuijten on 04 January 2012 with 0 comments

While it is very easy to create a “Form and a Report” on a single table or view (just follow the wizard), it is not always intuitive for end users that they should navigate to the form page to remove the record. A nicer solution is the one described by Anthony Rayner in this demo page. This solution uses a… Continue Reading →

Upgrade to APEX 4.1: Invalid Login Credentials

Alex Nuijten on 08 November 2011 with 0 comments

Always a good idea to upgrade on a Friday.. not… In the past I did numerous upgrades to the latest APEX release, and never really encountered big problems. It was always very smooth, kudos to the APEX-team. If something went wrong it was mostly my own fault, which I will admit now. Because of the history of going very smoothly,… Continue Reading →

How Long is this String?

Alex Nuijten on 15 September 2011 with 0 comments

A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ’0999′) Have a think, and then check out the answer on nuijten.blogspot.com.

Business Rule: Only One per Day, but Keep the Time

Alex Nuijten on 30 August 2011 with 2 comments

The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) Wouldn’t it be nice if it was possible to do it like this? This way you still have the complete date information (time is a component of the date column), and only… Continue Reading →