My little world of sharing

May23

RESTful web service in Oracle Application Express (APEX) 5 and integrate in the page

The RESTful web service is another cool feature has been included in the new APEX 5.x release. Now you can create web services directly from the APEX workspace and distribute data or integrate with other systems quite easily. You can read the details...
Read More
May21

Delete row/record using dynamic action and jQuery in the Oracle Apex 5.x classic report

Deleting record from a classic report using AJAX request was a big challenge in the earlier version of Oracle Apex applications. One of the things I like the most with the new version of Apex 5.x is the dynamic action. It is now quite flexible to integrate...
Read More
May21

Extend the leaflet map to add layers in Oracle APEX 5.x using jQuery and apex_json

I strongly suggest reading my previous article INTEGRATE LEAFLET MAP WITH ORACLE APEX 5 USING JQUERY AND APEX_JSON before reading this because I am just writing the extended javascript codes here. In the previous article, I have shown how to integrate...
Read More
May11

Integrate leaflet map with Oracle APEX 5 using jQuery and apex_json

Working with Oracle Application Express (APEX) was so boring before the APEX version 5 released. It was so hard to do stuff easily. I had to mess around with the style sheet as well as the core configuration files with trying to make changes to the theme...
Read More
May02

Creating database diagram in MS SQL server and getting authorisation error

Database diagram or Entity Relationship Diagram (ERD) is a very handy tool in the MS SQL server management studio. I found it very useful when working with a large relational database with many tables (entities). It helps to understand the data modelling...
Read More