Here is what I learnt today.
You can use logical operators in the RETURN clause of a function whose return type is BOOLEAN. So for example, you can write a function with the following structure:
create or replace function test_fn(p_param varchar2) return boolean as l_value varchar2(10):= 'TEST'; begin return false or p_param = l_value or length(p_param) = 5 ; end; / show errors;
Even after a month of wearing the iWatch, I can't really point at one particular feature that makes it worthwhile. It's really more (more...)
I used the employees table from the HR demo schema for my examples which is already available in Live SQL, so you don't have to create anything but the functions used in the scripts.
I've created 4 scripts:
Wherever you roam
And admit that the waters
Around you have grown
And accept it that soon
You'll be drenched to the bone
If your time to you
Is worth savin'
Then you better start swimmin'
Or you'll sink like a stone
For the times they are a-changin'.
-- From Bob Dylan's "The Times They Are A-Changin'"
Spent some time with (more...)
Yesterday, I was traveling from my home in Salt Lake to Oracle Corporate HQ in Redwood Shores. Having landed in San Francisco, I was in a rush to get my rental car, make the drive to HQ, and get (more...)
So, I suggested the DBAs to do strace (more...)
twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"
I found a solution on http://ubuntuforums.org/archive/index.php/t-1596636.html :
It was reported here for fedora: https://bugzilla.redhat.com/show_bug.cgi?id=509639. The workaround is to execute it with a specific shell variable:
$ export LANG
twm launches fine after this.
Oracle SSO Failure – Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured
Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host (more...)
I will be in Calgary next week presenting PeopleTools topics at the Western Canada Regional Users Group meeting. My sessions are at 1 PM and 2:15 PM. See you there!
During my undergrad days, when remote learning was done with smoke signals (no Internet yet), (more...)