Oracle Insights and Answers



Solving Oracle problems for over 20 years

Making Your APEX App Safer

by Rodrigo Mesquita | Apr 16, 2019 | APEX, Security

APEX uses the best of the modern web to create native web applications; unfortunately, this also brings modern vulnerabilities that we always need to be aware of. To protect applications, APEX has a number of in-built security features available to prevent SQL...

Explorer Recognised as Oracle Digital Partner of the Year 2019

by Explorer UK Ltd | Apr 5, 2019 | Uncategorized

"This award recognises the fantastic work we do with our customers and the outcomes we help deliver through Oracle Cloud and Hybrid Cloud implementations in collaboration with our peers in Oracle Digital. 2018 was another great year for Explorer through sustained...

Customising Workspace Login

by Matt Mulvaney | Mar 21, 2019 | Uncategorized

Ever logged in to an APEX Workspace using a page that looked like this…? Well this is the login page now presented to me when I log in to my local version of APEX running on a Docker instance of my laptop. But why would I do such a thing? And what’s the purpose of the...

OCEAN: A Methodology for Oracle Hybrid & Multi-Cloud Deployments [Video]

by Jon Lingard | Mar 5, 2019 | Uncategorized

There are a number of market trends impacting the rate and success of Cloud adoption for Oracle workloads, not least the co-existence of on-premise infrastructure with multiple cloud service providers. These Multi and Hybrid-Cloud trends are creating challenges for...

Choosing the Right Report and Features to Give Your Users When Presenting Data in an APEX Application

by Paul Jones | Mar 4, 2019 | APEX, Reporting

At a conference some time ago I was asked a question on enabled options on reports in an APEX application with regards what built-in functions should be enabled for the users. When I started thinking about the topic, I realised that the answer isn’t as simple as it...

Calling PLSQL from Javascript

by Rodrigo Mesquita | Jan 29, 2019 | APEX, JavaScript

For those who came from an Oracle Forms world it is very easy to start working with APEX. When creating simple screens, you don’t need any jQuery or AJAX knowledge as dynamic actions help you. However, there comes a point where applications get more complex and we...

What is the Oracle Forms Standalone Launcher?

by Colin Archer | Jan 21, 2019 | Oracle Forms

I recently attended the Tech 18 conference in Liverpool and sat in on a few Forms presentations where the new Oracle Forms Standalone Launcher (FSAL) was mentioned. As an Oracle developer who has spent many years working with Oracle Forms I was interested to know more...

Apiary and APEX

by Craig Sykes | Jan 14, 2019 | API

More and more projects I work on at the minute make use of RESTful Web Services. These can either be a way of exposing our own data or a way to make use of data from external systems. They are easy to create in the Oracle Database to surface your own data – check out...

Creating an Online Leaderboard in APEX

by Craig Sykes | Jan 10, 2019 | APEX

In my spare time I like to play around with creating video games in technologies other than Oracle (!). I recently created a game for an online community that I participate in and I was asked whether I could create a leader board to go with it. I had never done this...

Case Study: Generis Technology Ltd

by Devon Page | Jan 8, 2019 | Case Studies

For the past 16 years, Generis Technology Ltd, a wholly owned subsidiary of the global Landis+Gyr Group, has supplied a suite of applications under the B-Smart brand which supports interaction in deregulated energy markets. Utilising an Oracle Forms user interface,...