The Interactive Grid – Let’s customise it!

Roel Hartman is another speaker at #MALAGAPEX18 with more than one session. In this blog entry, we presented his session A Deep Dive into APEX JET Charts. 

malagapex - roel hartman

Today, we want to highlit the session titled as Top Ten Tweaks for the Interactive Grid.

The Interactive Grid is introduced in APEX 5.1 as a best of both worlds of Tabular Forms and Interactive Reports. Although a lot of settings are declaratively available within the APEX builder, there are a ton of features built in that are only accessible by JavaScript. In this session, you will learn how to use the most interesting “hidden” features with just a few lines of JavaScript.

Some examples:

  • Adding and removing buttons from the Interactive Grid toolbar.
  • Adding and removing actions from the toolbar menu.
  • Adding and removing functionality from the row level pop up menu.
  • Removing complexity on the column level.
  • Adding tooltips to a column.
  • Changing the layout of columns and headings.
  • Updating multiple records at once.
  • Refreshing (only) changed records within the grid.
  • Removing only deleted records from the grid – without a full refresh.

Something else you must know is that Roel is a very active user at twitter, so feel free to follow his account at @RoelH, and remember to check out our own twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

More low code so you can REST more

For this edition of #MALAGAPEX18, there are some speakers who will be sharing more than one session with us. One of them is Richard Martens. We spoke about another of his talks in this blog entry regarding (how to) Validate User input with Oracle APEX.

malagapex - richard martens

However, he’ll have another talk titled “Restful services and Remote SQL in Oracle” and as we know you like to know a bit more than the title, here are some more details:

Apex 5.2 offers the “remote SQL” feature, a way to use RESTfull services straight from APEX. The presentation will show how to consume RESTfull services using HTTP(s), GET, PUT and POST, not only to ORDS (remote SQL) enabled services but also from MySQL or Postgres databases…

There is still one more session from Richard (he’s going to be very busy), so don’t forget to stay tuned to our Twitter account (@malagapex) to get the latest updates about #MALAGAPEX18. And if you haven’t done so yet, go to this link to get your tickets!

Richard’s Twitter handle is: @rhjmartens 

Use node.js to monitor anything

We also have speakers from the house, and today we’re more than pleased with talking about Trond Enstad.

Trond is a Norwegian Entrepreneur and technical IT consultant, working in performance analyst and very well known troubleshooter. Trainer, mentor and public speaker, Oracle DBA – operations, development and engineering, Infrastructure – planning, sizing and engineering, Nearshoring/offshoring, ITIL, Multilingual and facilitator, with more than 25 years of technical experience in IT industry. Owner and CEO of and

Regarding his presentation, Oracle APEX & NodeJS – a match made in heaven, here is a quick summary:

Live build session of backend server stats collection agent and apex front end in 40 minutes. Backend agent build with NodeJS (javascript) using Oracle’s NodeJS driver to insert stats into remote db. Front end is build with Oracle APEX, OracleJET and timer plugin.

Integrating this type of services adds a great value to our apps, so you better put an eye on this session to get a bigger picture of what you can do with APEX. If you don’t have your tickets yet, follow this link and get ready for this session! Follow Trond at his twitter account (@OracleTuningGuy), follow our own Twitter account to stay tuned (@malagAPEX) and keep the track of the hash #MALAGAPEX18!


Coming without any slides and only Oracle JET

We wanted to talk today about Geertjan Wielenga, a very brave Oracle member coming to #MALAGAPEX18 without any slides…

malagapex - geertjan wielenga

Geertjan is an Oracle Senior Principal Product Manager for Oracle JET, Oracle’s JavaScript strategy for enterprise Mobile and Web development, based at The Netherlands. Writer, speaker, and trainer active in the software industry with a proven and consistent track record since 1996

He decided to submit an abstract titled “Oracle JET: No Slides, Just Code!“. Bellow, you can find a small peak about his talk:

What’s Oracle JET? JET is the JavaScript Extension Toolkit, which is Oracle’s official enterprise JavaScript solution. It is used throughout Oracle as the frontend user interface technology for all modern Cloud products, while it is also Oracle’s strategy for extending Oracle products, such as Oracle Sales Cloud, Oracle HCM Cloud, and more.

In this session, see how everything fits together, without slides, just code!

We think this one is a great opportunity to learn more about this Oracle resource from one of the people in charge of this powerful tool. Stop thinking now, go to the ticket’s platform, and get ready for this session! Don’t forget to follow Geertjan at his Twitter account (@GeertjanW), and remember to check out our own Twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

Agenda for malagAPEX18 is LIVE

You still have some more hours to get your Early-Bird tickets today, so that’s why we’ve chosen today for sharing the Agenda for #malagAPEX18!!

We haven’t filled all the gaps yet, but we want to let you know about most of the sessions and the great quality of speakers driving those talks. We’ll be linking these entries as soon as we publish the corresponding abstract’s entry with more details, so feel free to check this post in the future to get the full picture!

Day 1

31st May
Track 1 Track 2
8:00 – 9:00 Coffee & Registration
9:00 – 9:45 Opening session

& Key Note

10:00 – 10:45
10:45 – 11:15 Coffee Break
11:15 – 12:00 Building a large Image library using APEX

Niall McPhillips

Benefits of developing APEX applications on the Exadata Express Cloud Service

Roel Hartman

Oracle ACE Director

12:15 – 13:00 Structuring an APEX application

Alex Nuijten

Oracle ACE Director

Machine Learning in Action

Heli Helskyaho

Oracle ACE Director

13:00 – 14:00 Lunch
14:00 – 14:45 Life after Forms: The Move to APEX

Alex Nuijten

Oracle ACE Director

Oracle JET: No Slides, Just Code!

Geertjan Wielenga


15:00 – 15:45 Details Coming

Restful services and Remote SQL in Oracle APEX

Richard Martens

Oracle ACE

15:45 – 16:15 Coffee Break
16:15 – 17:00 Details Coming

A Deep Dive into APEX JET Charts

Roel Hartman

Oracle ACE Director

18:00 – 21:00 Social event

Day 2

1st June
Track 1 Track 2
8:00 – 9:00 Coffee & Registration
9:00 – 9:45 Design your databases straight to the Cloud

Heli Helskyaho

Oracle ACE Director

3D – Docker for Database Developers

Roel Hartman

Oracle ACE Director

10:00 – 10:45 Details Coming

Knock yourself out with APEX and knockout.js

Richard Martens

Oracle ACE

10:45 – 11:15 Coffee Break
11:15 – 12:00 Core9 (Jesus) Oracle APEX & NodeJS – a match made in heaven

Trond Enstad

12:15 – 13:00 Validate User input in Oracle APEX

Richard Martens

Oracle ACE

Details Coming
13:00 – 14:00 Lunch
14:00 – 14:45 Natural Language – modern user interface

Andrzej Nowakowski

Top Ten Tweaks for the Interactive Grid

Roel Hartman

Oracle ACE Director

15:00 – 17:00 Open Mic session

Expert Panel Discussion

& Coffee break

Feel free to comment to us how much do you like this conference agenda!! We’re so happy of having such great speakers, and we really want to make this initiative of spreading Oracle technologies, specially APEX, here in Spain!

Listen to Andrzej! Talk to APEX ! Eat pizza !

Today, we want to present the session by Andrzej Nowakowski titled: “Natural Language – modern user interface”. But let’s learn a bit more about Andrzej first.

malagapex - andrzej nowakowski

He’s an Oracle APEX integration developer with over 13 years of experience. Developer and moderator of the polish APEX Forum Blogger (, Founder,,

Regarding his presentation, Natural Language – modern user interface, here is a quick summary:

Developers since decades have used the same types of data input components like text fields, select lists, date pickers, etc. Although the style of interfaces is changing (other colors, other shapes or total other design styles),  they are still standard components. If the application must interact with public users or end users that can’t use a keyboard, a better solution is to use more natural interface. Until very recently, there wasn’t any alternative to standard GUIs. But this has now changed and you can build applications with modern, natural interfaces. One of the most popular interfaces is the voice recognition from Amazon… called –  Alexa. With Alexa, you can build natural voice applications that offer users a more intuitive way to use.

In this presentation, we will build a real-world APEX application to order Pizza via the voice interface. To build this solution we will only use APEX with ORDS and Alexa Kit.

You shouldn’t be missing such a great opportunity to integrate Alexa and APEX. That’s why you have to follow our Twitter account (@malagAPEX) and keep the track of the hash #MALAGAPEX18!


Digital Content: image library the Swiss way

As we continue talking about our speakers, we want to focus today’s post on Niall McPilips.

malagapex - niall mc phillips

Niall has been developing using Oracle since Oracle V5. He has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005.  Niall has developed a number of large, multi-lingual applications for multinational companies and organizations all over the world.  Several of these receives tens of millions of page views per year.  Niall is a strong believer in APEX solutions because of their stability, scalability, and rapid development speed.  Niall is also the organizer of the Swiss APEX Meetup group.

For #malagapex18, he has submitted an abstract titled “Building a large Image library using APEX”. Here you can find a quick summary of his talk:

This case study will describe the approach and challenges faced when overhauling a 14-year old image library of over 40’000 photos. The new version was developed using Oracle APEX 5.1, Oracle Multimedia, Oracle Text and PL/SQL. Issues addressed include automatic extraction of image metadata to facilitate searches and image description, automatic resizing of images using Oracle Multimedia, customization of APEX reports to produce a modern presentation format for the photo library.

We really look forward to attending Nial’s presentation. Meanwhile, you can follow his Twitter account @Niall_McP, and don’t forget to stay tuned to our Twitter account (@malagAPEX) to get the latest news on #MALAGAPEX18!

The queen of database design – now in the cloud

Here we have a new blog entry about another of our great speakers. In this post, we’d like to talk about an Oracle ACE Director and European Oracle User Group Ambassador: Heli Helskyaho.

malagapex - heli helskyaho

She is the CEO of Miracle Finland Oy and an Ambassador for EOUC (EMEA Oracle Users Group Community). Heli holds a Master’s degree (Computer Science) from the University of Helsinki and she has specialized in databases. At the moment she is working on her doctoral studies, researching and teaching at the University of Helsinki. Her research areas cover Big Data, multi-model databases, schema discovery and methods and tools for utilizing semi-structured data for decision making.
Heli has been working in IT since 1990. She has held several positions but every role has always included databases and database design. Heli believes that good database design and good documentation reduces performance problems and makes solving them easier and we do not disagree with this. A great APEX application starts with a great database design.

Appart of being an Oracle ACE Director and a very frequent speaker at many conferences, she is the author of Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and a co-author of Real World SQL and PL/SQL: Advice from the Experts (Oracle Press 2016).

Having such a great background, we had to ask Heli for more than one session. However, today we’ll be highlighting only one of those sessions, titled: “Design your databases straight to the Cloud”. Here follows a sneak peek on this session:

Everybody is talking about Cloud. How does the Cloud change my work as a database designer? What should I know and what new to learn? In this session, we will talk about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer.

You can check her Twitter account at @HeliFromFinland. She’s very active, and always sharing interesting content with the community. Stay tuned to our Twitter account (@malagAPEX) to get the latest news about #MALAGAPEX18!

Let’s Jet-Set with Roel and Oracle Jet

Today, we’ll put our focus on Roel Hartman, to learn a bit about his background and the talks he’ll drive at #MALAGAPEX18, the upcoming 31st of May and 1st of June.

malagapex - roel hartman

He started a long time ago using Oracle RDBMS 5, Oracle Forms 2.3, RPT/RPF and Oracle*Case 4.5. Since a few years, he has been focussing mainly on Oracle Application Express. Roel has been a speaker on UKOUG, OOW, Collaborate, ODTUG’s KSCOPE and a number of local Oracle User Groups. Within ODTUG he acted as the APEX Content Lead for the Kscope14 and KScope15 conferences and is a member of the Board of Directors. He keeps an (APEX-related) blog on In June 2009 Roel received an Oracle ACE award and in August 2010 he was appointed Oracle ACE Director. Roel was a co-writer of the “Expert Oracle Application Express” and “Oracle Application Express for Mobile Web Applications” books. Roel is Director at APEX Consulting in The Netherlands.

Today, we want to highlit one of the sessions from Roel, titled as A Deep Dive into APEX JET Charts.

In this session, we will take a closer look at the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile investigating. You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to impress your boss.


  • What is Oracle JET.
  • Declarative JET integration in APEX.
  • Modify the JET charts using Dynamic Actions and a few snippets of JavaScript.
  • Use other JET components in APEX.
  • Building an APEX plugin for a JET component

Something else you must know is that Roel is a very active user at twitter, so feel free to follow his account at @RoelH, and remember to check our own twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

Alex Nuijten shows you the structure

In this post, we’d like to present you to the one and only dancing ((#ougn18)) APEX developer Alex Nuijten.

malagapex - alex nuijten

This very well known speaker, awarded the Oracle ACE Director membership back in August 2010, is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX) and Alex is a member of the Smart4APEX team. Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards. He wrote many articles in Oracle related magazines, and at regular intervals, he writes about Oracle Application Express and Oracle database development in his blog “Notes on Oracle” ( Alex is also a co-author of the following books “Oracle APEX Best Practices” (published by Packt Publishers) and “Real World SQL and PL/SQL” (published by Oracle Press).

For #MALAGAPEX18, he’ll be talking about Structuring an APEX application. Here are the details:

Creating beautiful applications with APEX is easy, especially after the introduction of Universal Theme. It is easy to follow the wizards and drop SQL and PL/SQL all over the place in your application thereby creating a maintenance nightmare. When a table is changed, which pages are affected? How can you easily find out? Getting the structure of your application right requires a method to follow. In this session, I will share my thoughts on structuring your APEX application. This session will focus on just that: build robust applications; leverage views, packages, instrumentation, etc.

If you don’t want to miss anything of what Alex has to say, don’t forget to follow his Twitter account at @alexnuijten. For sure, you all will enjoy the talks of this dancing APEX developer.

Don’t forget to stay tuned to our Twitter account (@malagAPEX) to get the latest news about #MALAGAPEX18!