New REST features of 18.1 (Early Adopter 2)

I recently published a set of blogs on the subject of ORDS, Outh2 and Web Services in APEX 5.1. In part three (available here) I detailed how to use a REST Service as the source for an Interactive report. This involved the following steps: Define the REST Service within Web Service Modules. Call the Web […]

Blog, Uncategorized 18.1, RESTful / April 11, 2018

Read More

Oracle Cloud: Universal Credits. What you need to know…

In September 2017, Oracle announced a change to their Cloud pricing and transaction model for end users and partners alike. The change was born out of poor customer experience with contracts and billing on their previous model along with frequent internal challenges to provide a streamlined “wash, rinse, repeat” billing and payment mechanism for consuming […]

Blog, Cloud, How to, Licensing Cloud, Licensing, Oracle Cloud / March 21, 2018

Read More

Interactive Grid Column Read Only Control

I thought it would be interesting to share my findings on the Read Only setting for Interactive Grid (IG) Columns. The Read Only attribute has been around for many years – so why write a blog about it in 2018? Well, something has changed with the Read Only attribute for Interactive Grid columns – here […]

APEX, Blog Interactive Grid / February 16, 2018

Read More

APEX Interactive Grid: Preventing Lost Updates & Record Locking

I was recently asked about the Interactive Grid (IG) configuration settings that are associated with Locking and Preventing Lost updates. “Aren’t they the same thing?” I was asked… Actually, no; they are not the same thing. However, they are both there to protect your data and therefore it is worth spending a little time to explore […]

APEX, Blog, How to / February 12, 2018

Read More

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 database and navigate an APEX application using voice commands. If you were there and visited our stand then you might have also seen our […]

Blog, IOT Alexa / January 24, 2018

Read More

Introducing APEX TabLock

A little side project of mine is developing new features for a chrome extension which provides extra functionality for the APEX developer. The chrome extension is called TabLock and the name derived from its original purpose, which is to help prevent accidental movement of APEX page designer tabs. However, I am aware that this extension […]

APEX, Blog APEX, APEX 5.0, APEX 5.1, Chrome / January 17, 2018

Read More

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 you how to authenticate calls to protected Web Services and how to process paginated JSON response data. Typically the Web Services would be […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / January 11, 2018

Read More

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 to load Excel data into APEX applications. At the UK OUG TECH17 Conference, I introduced a number of options available to help import Excel data into APEX […]

APEX, Blog, TECH17, Why use APEX APEX, Excel / December 21, 2017

Read More

Oracle Forms – The venerable statesman with a cloudy future

Back in August 2015 I wrote a blog titled ‘The Future of Forms’ and a colleague of mine, Jon Lingard, followed this up in December 2015 by writing a continuation based upon his experience; ‘The (continued) future of Oracle Forms’. As two years have passed since these blogs were published, I thought it was time […]

Blog, Oracle Forms Oracle Cloud, Oracle Forms, upgrade / December 14, 2017

Read More

Getting to Grips with the APEX Interactive Grid API

Whilst attending Tech17 at Birmingham this year, I was pleased to see David Peake provide a short demonstration of the Oracle Interactive Grid API documentation. The documentation format/style, using JSDoc, differs from the traditional APEX documentation style we are used to. However, from the quick demo I saw, it does look great, and I cannot […]

APEX 5.1, Blog APEX 5.1, Interactive Grid / December 8, 2017

Read More

Next Page »

Featured Posts