Today Oracle introduced
the node-oracledb driver, so you can easily connect from node to your Oracle database.
Previously I blogged
about the Oracle VM you can download so you have your own local Oracle environment. Below are the steps to install the node driver and run a first example in that environment.
(Also read the official node-oracledb installation guide
for a local database - 4. Installation with a local database).
First we need to install git (more...)
Roeland organised a new APEX Meetup in Belgium
on February 2nd.
This time no specific topic, everybody can get on stage for maximum 5 minutes to show something they did or to ask some feedback or help on a specific problem.
If Belgium is to far, no worries, there're meetups
planned all over the world.
The next meeting in the Netherlands
is on February 18th organised by Alex, Christian and Roel.
But as I said, (more...)
The fastest and easiest way to setup your own local Oracle Development environment is by using the "Oracle Technology Network Developer Day" Database Virtual Box Appliance
- Oracle Linux 7
- Oracle Database 12c (126.96.36.199) EE (CDB/PDB)
- Oracle Rest Data Services (ORDS)
- Oracle Application Express (APEX)
- Oracle SQL Developer and Oracle SQL Developer Data Modeler
: Download and install Oracle VM VirtualBoxStep 2
: Download the VM image
that contains (more...)
Did you know you can recognise an Oracle APEX application through the url?
Here's the syntax:f?p=appid:pageid:session:request:debug:clearcache:params:paramvalues:printerfriendly&p_trace=YES&cs=...
Let me give some examples:
The first part: https://www.apexrnd.be/ords/
depends on your configuration. I'm using https, my domain name is apexrnd.be and I'm using the Oracle REST Data Services as connection to the database. This is a configuration in your webserver.
The next part is f?p=
f is a (more...)
In the previous post
I talked about Master-Detail and that it wasn't that easy to do Master-Detail-Detail today declaratively in APEX 4.2 (and 5.0).
Below is a screenshot of FOEX
(a framework build on top of APEX) and a Master-Detail-Detail in there.
You can see the live example at https://www.apexrnd.be/ords/f?p=FOEX_FDOCS:MASTER_DETAIL_DETAIL:0::NO:::
Here's a screenshot of the page behind the scenes:
At first it might seem complex, but it isn't. In FOEX (more...)
In the last posts we used following tables to show (Report)
and edit (Form)
Another way to work with this data is using a Master-Detail report/form.
In the master we have our customer info and in the detail the products he's interested in.
Oracle APEX provides a wizard to create a Master-Detail Form
You just follow the wizard to set it up:
By default the wizard will only show related tables, which is (more...)