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

APEX & Search

This year, we have been looking into the best way to deliver search capabilities in an APEX application. Customers are used to searching in Google and often want the same functionality in their business application.  While we don’t have the resources and years of research that Google have, we can take some ideas from them […]

APEX, Blog APEX, Search / November 30, 2017

Read More

ORDS, OAuth2 & Web Services in APEX – Part 2

Protecting Web Services with OAuth2 In my previous blog, I took you through how to create RESTful Web Services with ORDS and how to test them with a REST client. This blog will build on those Web Services (Fig.1) and show you how you can protect them to ensure they can only be accessed by […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / November 13, 2017

Read More

Why invest in Exadata

Generic infrastructure gives you generic results. Exadata is a converged infrastructure solution that solves problems with Oracle Database performance, availability, scalability and recovery. Originally released in 2008, Exadata was actually an “alliance” solution between Oracle and Hewlett Packard and an example of how many converged infrastructure solutions are still created today. Oracle quickly realised that […]

Blog, Explorer Engineered Systems, ODA / November 9, 2017

Read More

ORDS,OAuth2 & Web Services in APEX – Part 1

Creating your first Oracle REST Web Services 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 them with OAuth2 and how to test them with a REST client. The second […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / October 30, 2017

Read More

bg-goldengate

Oracle Goldengate or Dbvisit Replicate?

Oracle Goldengate release 12.2 Versus Dbvisit Replicate release 2.9 These two products offer data capture functionality and replication between multiple Database environments covering both Oracle SE and EE versions. They essentially operate by reading the source Database redo logs and pushing the data changes across to the target Database. However, there are some Important differences […]

Blog, Explorer, How to Data Replication, Dbvisit, Goldengate / October 23, 2017

Read More

Next Page »

Featured Posts