DSP Blog: Oracle APEX (12)

-->

Latest Posts

08-Mar-2018 11:42:31

APEX Developer Mode

When I used to work with Oracle Forms, the company I worked for used to grant users on the development environment with a special role which provided enhanced access to many areas..

12-Feb-2018 08:58:34

APEX Interactive Grid: Preventing Lost Updates & Record Locking

Find out how we can help you build solutions using Oracle APEX with our award-winning application development and consultancy services. I was recently asked about the Interactive..

24-Jan-2018 15:51:49

Querying an Oracle Database Using Amazon Alexa

At the UKOUG Tech17 conference last year, I delivered a presentation called APEX and the Internet of Things. As part of this presentation, I wanted to demonstrate how to query the..

11-Jan-2018 10:34:01

ORDS, OAuth2 & Web Services in APEX – Part 3

Calling Web Services from APEX The following blog will show you how to call GET method Web Service from an APEX 5.1 application and extract the response data. It will also show..

21-Dec-2017 10:07:04

Options For Loading Excel Data Into APEX Applications

Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary..

30-Oct-2017 10:08:26

ORDS,OAuth2 & Web Services in APEX – Part 1

I recently gave a presentation on how to get started with Web Services at the UKOUG APEX SIG in London. The first half covered how to create Web Services with ORDS, how to protect..

09-Oct-2017 10:00:47

Validations and Duplicate Page Submissions in APEX 5.1

I had a problem with a modal dialog page in APEX 5.1, which created new rows in a table on the database whenever the Create button was pressed. The problem was that if the user..

19-Sep-2017 10:56:55

QuickSQL – Saves you time

One of the new features of APEX 5.1 definitely changed my way of creating DDL on Oracle databases. With the Quick SQL packaged application you only need to write minimal lines of..

29-Mar-2017 16:41:30

A Review of Interactive Grid in APEX 5.1.1

This blog has been a long time in the making… Of course before writing a blog on any subject, you have to do your research. In my case, my research involved creating dozens (maybe..