Data Densification in Oracle APEX


Data is often stored in sparse form and business often wants to see data in a more organized and explicit fashion. Report developers working across reporting tecnologies face a requirement to show a record with a '0' in the measures columns if no data exsists for a particular combination of (more...)

Creating dynamic breadcrumb chains in Oracle APEX


This article is borrowed from one of the topics of my book (http://www.packtpub.com/oracle-apex-4-2-reporting/book) on Oracle APEX 4.2 reporting. I wish to talk about the process to engineering breadcrumbs of varying lengths in this article. Let me explain the motive with an example.


Let us say (more...)

Tracking the running reports in OBIEE 11G

 
I faced a rather strange but relatively simple requirement a few days back. The client had employed a resource to refresh the sessions page and capture the running queries from it and mail it to a team that dealt with performance tuning. This is certainly not the most efficient (more...)

Sangam 2013


Just read about http://www.sangam13.info/.The event has been cohosted by AIOUG and India OAUG

Such events are indeed rare and few in India. Really hope this to be a trendsetter.


Sangam has been instrumental in introducing Jonathan Lewis, one of the most credible voices on Oracle, as (more...)

ESRI map with Google map and map viewer in APEX


This article is in continuation of my previous workon Oracle Map Viewer/Map Builder and Oracle 12c database.

This article demonstrates the conversion of ESRI maps to datatype (SDO_GEOMETRY) that can then be used in Map Viewer. The article ends with an HTML code that can be put in APEX's HTML region to display the map with ESRI info on it.


Let’s start

1.    Get an ESRI map. I got it from http://www.mapmakerdata. (more...)

My take on using Mapviewer with Oracle 12c and Google maps API



Map viewer is a kool technology and I wanted to write about it for a long time. 


Let me first chalk the steps that we will follow. We will


1. Download Map Viewer and Map Builder.

2. Create a pluggable database (pdb), create a pdb user and grant the (more...)

Description of my book on Oracle APEX 4.2 reporting



Oracle APEX 4.2 reporting is designed to bring the best of the reporting world for intermediate –advanced readers. The book is available at http://www.packtpub.com/oracle-apex-4-2-reporting/book. It is designed to expose APEX developers to other reporting solutions, inform them about the strengths of each of these and to enable them (more...)