It doesn't seems to(it's raining alot in Belgium at the moment), but summer is coming!
And summer brings... technology!
And that's why Contribute Group presents: Summer Of Technology
Summer Of Technology is a series of free workshops in July and August.
Twenty(!) workshops about innovative development, design and management tools.
And of course, several workshops about Oracle technologies:
Today I passed my exam for Oracle PL/SQL Developer Certified Professional(OCP)... Hurray!
Oracle Application Builder Cloud Service(ABCS) is generally available now.
ABCS is an all-in-one box: software development and database in one service.
Oracle ABCS provides a platform to not only create mobile and web applications in the cloud, but also deploy and host them in a cloud environment.
Development happens in a web browser on a intuitive way by drag&drop objects in a visual environment.
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.
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.
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:
Oracle Compound triggers can be handy when you need to share common data in various timing points, e.g. solving a mutating table problem. You can find an example on the Oracle base website.
For those that are using compound triggers, before 12c the order of the sections were restricted: