After I looked through the chart types supported by the new Oracle JET framework
I asked myself if we need other chart plugins like D3JS or RaphaelJS in future APEX releases anymore?
The answer is: Yes in special cases.My supposition is that we can use all available JET charts in one of the next versions of Oracle APEX.
Now I will describe the "special case" with two examples where other chart frameworks still make sense:Mehr »
If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility.
While the (more...)
On Twitter today, Jeff Smith tweeted about a new SQL Developer cheat sheet that he created with a site called cheatography.com.
Not to be outdone, I created a cheat sheet for the APEX 5 Keyboard Shortcuts. Not only can you view it online, but you can also download a PDF version of it. Check it out and let me know if there's anything that you'd like to see added.
Last month was the annual election for the Board of Directors of ODTUG. And just like the year before, I was one of the 19 (!) candidates for one of the 5 spots.
During the campaign and election periods I received a lot of positive feedback and my hopes were high - but the competition was extremely strong. During Oracle Open World the results were announced and I was notified I hadn't made (more...)
I added a new feature request for APEX:APEX 5.1 with support for all available JET Data Visualizations ChartsDescription:
) which are supported in the current version of APEX. For example the "Spark Chart" or the "Timeline" will (more...)
Just a simple example how easy APEX can handle this kind of problem.Example:
We have today the 06.11.2015 (11-06-2015) and we have two date values 01.11.2015 and 30.11.2015.
Now I want to know how much time has past in percent since the beginning (01.11.2015):
Result: 17 %Mehr »
In migrating SERT from 4.2 to 5.0, there's a number of challenges that I'm facing. This has to do with the fact that I am also migrating a custom theme to the Universal Theme, as almost 100% of the application just worked if I chose to leave it alone. I didn't. More on that journey in a longer post later.
In any case, some of the IR filters that I have on by (more...)
I'm a huge fan of APEX's new Universal Theme, and have been working quite a bit with it. One of the coolest features is how easy it is to change the colors. You don't even need to be good at design - just click Theme Roller, and spin all the things!
However, as much as you change the colors, the look and feel still largely looks the same, since the base font is unchanged.
If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.
Oracle Live SQL
is a great source for learning SQL and PL/SQL. It has a lot of good examples and interactive educational tutorials. The best thing is, it runs on APEX ;) Add this site to your bookmarks.
Oracle Application Express 5.0.2 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.2, you can get it from the Downloads page on OTN. If you have Oracle APEX 5.0.0 … Continue reading
The next Oracle APEX NOVA MeetUp is going to be held on November 12th, 2015 at 7PM. We decided to mix things up a bit and are going to have it at Vapianos in the Reston Town Center. We're also going to try a more informal agenda. In other words, there will be no agenda.
So if you're around Reston on November 12th from 7-9PM (or so), feel free to stop by. Here's the MeetUp. (more...)
Only 3 days left to submit your abstract for KScope 16... so don't wait longer, submit
My first ODTUG conference was in 2006 and it was awesome. On this blog you'll find different blog posts about my experience and why I love it, so I won't go over that... but from time to time I get some questions about being a presenter at the event."What should I submit, I don't know what (more...)
Oracle Database Developer Choice Awards 2015
I was just looking at the voting results for ORDS
. In the ORDS category Dietmar Aust
is leading and in the category APEX it is Morten Braten
. So far so good. These men deserve the award for sure - they did a lot for the community and the most of us are using (or have used) their solutions. Think of Morten's PL/SQL Utility Library
or Dietmar's PDF Printing
The only thing I have (more...)
today was the deadline for uploading the four-page abstract / summary of my presentation at the German Oracle conference in Nürnberg:
If you still have to upload yours, hurry up ... only a few hours left ;).You can have a look here (it is German though ;).
See you in Nürnberg in November.
In 2008 I blogged
about how to add Group Headings into an Interactive Report in Oracle Application Express (APEX 3.x!).
Here's an example what I mean with Group Headings, you want to logically group certain columns (e.g. Empno, Ename) and have a group name above them (e.g. Group 1):
The approach I used at that time worked, but it required a lot of manual work. In 2009 Martin D'Souza improved it (more...)
In a comment on my post APEX 5.0: pimping the Login page
I got a question how to put your own logo or a custom image on the login page, instead of an icon.
You only need a bit of CSS to do the trick:
You can add the above CSS to your login page - Inline CSS in page attributes or you can add it to your page template or custom CSS in (more...)
On September 13th I got a nice surprise, an email of Steven Feuerstein with the message: "You have been selected as a finalist in the ORDS category for the 2015 Oracle Database Developer Choice Awards
It's always nice to get recognition for the efforts you do, so thanks so much already for the nomination. I didn't make publicity yet in order to get some up-votes, but I hope by reaching out to the people (more...)