OTN Appreciation Day : Functions returning record structures

Tim Hall, the man behind Oracle-base.com invited all Oracle bloggers to write a post about their favorite Oracle feature and this as a kind of appreciation of the Oracle Technolgy Network.

Contribute Summer Of Technology

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:

Oracle PL/SQL Developer Certified Professional

Today I passed my exam for Oracle PL/SQL Developer Certified Professional(OCP)... Hurray!

Oracle Application Builder Cloud Service(ABCS)

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.

Looking back at the Oracle Forms 12c event organized by Contribute(28/01/2016)

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.


Topics were:

Oracle Forms 12c: support policy

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.

Oracle Forms 12c: Install

I can go explain the full installation, but to be honest, I followed the guides of ORACLE-BASE.  


These are the guides I followed to install Forms and reports:

Scripts “All Things Oracle” article on Oracle Live SQL

I've put the scripts of my All Things Oracle article "About functions, records and result cache" on Oracle Live SQL.  This makes it easier to test the code used in the article.  

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 Forms 12c arrived!

It's here!  The latest version for Oracle Forms is now 12c!
Download can be found here.

A few months ago I wrote a blog post of possible new features.
I'm looking forward to explore the new version the next few days to see what's in it.

Oracle Compound trigger sections

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: