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...)
Oracle is gearing up to release APEX 5.0... the final early adopter release (EA3) will be released soon. Over 6000 people participated in APEX EA2...
Here's the email of Joel Kallman:
As EA3 will be very close to the final release of APEX 5.0 many more people will probably join EA3, so keep ready for it! I look forward what color scheme people will create with Theme Roller and how they make the (more...)
In the previous post
I showed some options how you can represent a many-to-many table relationship in a report using the LISTAGG Oracle function.
In this post we will edit a record and see how we can represent the data in a Form and save the data back to the different tables.
First I create a Form on the main table (customers) by just following the wizards.
Next I'll add a Shuttle item to the (more...)
Consider my case: I've a customer table and a products table. Customers can select multiple products they want to have. The diagram look like this: Customers on the left, Products on the right and a table in between that says which customers like which products. Customers might have multiple products and products might be linked to multiple customers - so a many-to-many relationship.
There're many ways to represent this data in a report. Here's a (more...)
In the previous post
I talked about scalable vector images. In this post we will integrate Font Awesome in our APEX app, but the steps for the same if you would pick another library.Step 1:
we need to make the library available in our APEX application.
The easiest way to make the library available in your entire application is to add the following line in your Page Template:
How do I know it's that (more...)
In 2015 most APEX-only conferences are scheduled in history. I definitely recommend to attend at least one of the conferences as it's a great time to meet other people, industry experts and the APEX Development Team.
You'll find me at following conferences:25-MAR-2015: APEX World - Rotterdam, the Netherlands
Every year a hit - and this year extra special as it will be at a different location - the beautiful SS Rotterdam. It's not decided (more...)
For a couple of years now webdesigners and developers don't use image icons anymore, instead we moved to scalable vector icons.
Before you had to create different images for the different formats and colours you wanted. Then to gain performance we created one big image with all those smaller images in it (called a sprite).
Next with some CSS we showed a part of the bigger image. A hassle...
In fact the evolution of using (more...)