Some of Dr. Pareto's work is based on the Pareto Principle: the idea that 80% of effects come from 20% of causes. In the real world, we continually see examples of the Pareto Principle.
I've been conducting one of my informal surveys (more...)
Read and monitor Oracle related blogs and news sources, all in one place.
The title of the Contribute event/seminar was "Oracle Forms 12c: Built to last".
Indeed, Forms is built to last. It has been around for over 20 years and it's added to Oracle Fusion Middleware 12c, which is supported until 2023.
Oracle Forms is still running at a lot of Belgian companies looking at the turnout.
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.
Amazingly, the (more...)
Next up in our ‘How I Work‘ series is Dan Iverson. Dan – together with partner-in-crime Kyle – runs the PSAdmin.io blog. If you’re a PeopleSoft administrator and connected to the Internet then there’s no doubt that you’ll have heard of their blog as they’re really prolific and have posted some great content. Clearly blogging wasn’t enough however, and there is now the PeopleSoft Administrator PodCast which is ~45 minutes of topical awesomeness. I (more...)
Oracle did an update of the support document for Fusion Middleware.
Fusion Middleware 12c(12.2.x) is supported until October 2023(extended support).
Of course this includes Forms and Reports!
But you can also see that the premier support for Forms 11gR2 ends at the end of this year!
Just to remind you, the support is (almost)the same for premier and extended, but you'll have to pay an additional fee for extended support.
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;
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: