DSP Blog: Oracle APEX (14)

-->

Latest Posts

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

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

28 Mar 2017, 15:47:07

Dynamic Theme Style in APEX 5.1

One of the new features of APEX 5.1 is the introduction of APEX_THEME API which enables you to change the application theme style by user.

1 Mar 2017, 14:08:56

A complete guide to #ORCLAPEX Dynamic Actions

Last year, Craig Sykes and I were discussing ideas for presentations at Tech16 and one idea made us quite excited to turn in to a paper for submission.