Oracle Insights and Answers



Solving Oracle problems for over 20 years

Build a Chatbot on Your Lunch Break

by Craig Sykes | Jul 3, 2019 | Chatbot

I’m primarily an APEX developer, and one of the things I love about APEX is how I can create something impressive in such a such a short space of time. I can build an application in my lunch break to solve a problem or make someone’s life easier. This is not the case...

Loading Excel into APEX 19.1

by Philip Ratcliffe | Jun 19, 2019 | APEX, API

Loading Excel Into APEX Applications Update Back in December 2017 I presented at Tech17 and published a blog outlining a number of options for loading Excel data into APEX applications (see Options For Loading Excel Data Into APEX Applications). One of the findings...

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...