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...)
After I described how to successfully import XML files
into an APEX application and gave some basic information about the analyzing of xml data
It's time for another example. This time we want to get all detail elements of a master element in one row.
Example XML data:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<team name="SG Dynamo Dresden" league="3. Liga"/>
<team name="RB Leipzig" league="2. Liga"/>
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...)
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...)
You need some sample data sometimes too? When I'm showing some new concepts at a customer or when I'm doing some training I just want some "random" data. Well, it's not really random data, it's a specific type of data I need depending the column and it should be a text that is somewhat meaningful and not hard to read like "1RT3HFIY".
When my wife is doing design and lay-out and she needs text, she's (more...)
Here's a screenshot of the result we want: the negative numbers are highlighted in red.
There're many ways to achieve highlighting certain areas in a report, but depending the complexity of the logic that defines what gets highlighted I use one of the following three techniques:
- CSS only
- CSS and a Dynamic Action with one line of JQuery
- CSS and a column in the SQL query that defines the class
Previously I announced I would start a chain of blog posts related to Oracle Application Express
. Next to the blog posts I'll build up a supporting APEX application where you can see the result of what I explain in real-time.
So, to start the chain I'll create a new APEX application. Almost in every project I start my APEX application the same way. Note that the screenshots are from APEX 4.2.6, as of (more...)
The year 2014 was the 10th anniversary of Oracle Application Express (APEX)
. I still find it unbelievable 10 years have pasted. Time flew by... you might think that after 10 years of building APEX applications the technology is out-dated or you get tired of it, but more the opposite is true.
Oracle Application Express is a web technology and the web evolves fast, which keeps it interesting and fun. We can follow the latest and (more...)
Completly rewritten new version of APEX Blogging Platform is now released.
Der Umgang mit CONNECT BY ist für mich immer wieder ein Highlight. Ob Positiv oder Negativ lasse ich mal außen vor. :)
Unbeachtet meiner Meinung ist es die sinnvollste Lösung um Baum-Verkettungen zu generieren.
Eine Anforderung die ich zuletzt gleich zweimal lösen musste war die Darstellung der finalen Ketten.
Das Ganze war recht einfach mit Hilfe einer analytischen Funktion zu lösen:
Last week I spent 4 days at the annual UK Oracle User Group conference, this time around called Tech14
. It was my first UKOUG
conference in a number of years and I set out with the intention of treating it like an all you can eat buffet of APEX presentations and workshops.
So, what were the APEX highlights of Tech14? Well, I have to start with the presentations given by Joel Kalman
, David Peake (more...)
In my previous post
a couple of days back, I demonstrated a simple Apex demo
pulling dynamic data from the database in the form of a bubble chart. I promised to share the code so here it is.
I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on. I don't post often these days, which I blame on work and family commitments, but is actually just down to pure laziness. Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming. (more...)
Just checked if the http://www.odtug.com/apex
is available again and it is. It seems the people there are filtering blogs because I don't see my blog post
from yesterday appearing there and I don't understand why. Is that just because I said that the old blog listing was much better? Or this is just another technical problem they have? Am I going to be removed from that blog listing forever if I continue saying (more...)