The Interactive Report has this great download feature where you can export everything you can see.
Anyway there are circumstances where the customer doesn't want that feature open for everyone.
In APEX you can only choose if you want the download button or not.
Even so APEX can't do it out of the box. There is a way to make your application able to do it.
Since APEX 5 you can't download when the "Download" (more...)
Many of you are still using the old "Component View" but the "Page Designer" introduced in APEX 5 made the developer life much easier.
The top 5 most time saving abilities for me are:
1. Easy access on all page elements (without any page refresh)
2. Copy&Paste of items, regions, dynamic actions, ...
3. Drag&Drop moving of items and regions
4. Multi edit of items
5. Since APEX 5.1: The ability to customize your (more...)
A lot of you are using jQuery to customize visual parts of an APEX application. I probably to often do so myself but there is a much more elegant way: CSS
Nowadays you are able to add different kind of rules into your CSS styles. In this example I will show you how to get into the topic by changing an Interactive Report (IR). In my example I want to change the typical group by (more...)
Execute a "Dynamic Action" by clicking on a button/link inside a report row is mostly handled by some triggering HTML class.
It actually works in 95% of all cases. But it is not the best way to do it. It is much more effective to execute the "Dynamic Action" with a custom event.
Reason is simple: You don't need to allocate unnecessary elements via a class by jQuery. You execute the "Dynamic Action" in the (more...)
Sometimes you just feel like you would be a newbie in coding business applications. Luckily it doesn't happen so often anymore. But this time it hit me hard. :)
During an application upgrade on Universal Theme I discovered an ugly workaround to create custom error messages I used in that time.
The old code looked like that:
p_cust_id := :p1_cust_id;
p_status := 0;
p_upduser := (more...)
A few days ago I tweeted about a solution from Martin Giffy D'Souza
to hide a specific column from export.
In my case I needed some username columns to be displayed during run-time but only exportable for administrators. The export itself was made with the default APEX (more...)
The last year was quite successful even so it was a pain in the ass in many ways.
I have been on 3 conferences, made a few blog posts, got member at DOAG #NextGen, I initialized the "APEX Dashboard Competition
" and I created a quite complicated example application which creates new solvable business cases for many of you: SVG in APEX
This wouldn't be possible if I would have been alone. I worked (more...)
In the last 8 month
I was working on a new version of my SVG (Raphaël) example application. Of course I have a job (freelancer) and I have children. So the time to spend was diminished on only a few hours per week mostly on my way to work.
Some of the results were presented at the Swedish Oracle meetup
in Summer '16. But the final application was made for DOAG 2016
What leads me (more...)
Most of you probably know the "Quick Outline" function you have inside the SQL Developer.
It helps you to easily jump between different functions/procedures inside a package.
My colleague Holger told me about a bug in SQL Developer 3.x where you could use the "Outline" view with normal SQL files, too. Unfortunately in version 4 it didn't work anymore. So he stayed with version 3 for a long while. Otherwise he would had to (more...)
InfoDie Select-Statements in diesem Blogpost habe ich von anderen Webseiten kopiert. Daher ist dieser Beitrag eher als Zusammenfassung unterschiedlicher Lösungsversuche zu sehen und dient mir als schnelle Hilfe bei der Verkleinerung eines zu großen Tablespaces. Schaut euch die Quellen an, die sehr viel detaillierter auf die jeweiligen Probleme eingehen.
Wer kennt nicht die Situation? Der DBA ruft an und meint der TEMP Tablespace verbraucht mehrere hundert Gigabyte an Speicher.
Was ist in solch einer (more...)
Die diesjährige DOAG war für mich anders als die Jahre zuvor. Dieses Jahr lag mein Fokus weniger auf Vorträgen, sondern mehr auf Community-Aktivitäten und Jugendarbeit.
Daher habe ich diverse Unconference Sessions besucht und viele Unterhaltungen geführt. Dabei habe ich zum Beispiel erfahren, dass es eine neue Community innerhalb der DOAG gibt - die DOAG NextGen
. Bei der es darum geht, junge Menschen für Oracle zu begeistern.
Das größte deutschsprachige Oracle Event des Jahres steht vor der Tür.
Die DOAG Konferenz
vom 15. bis zum 18.11.2016.
Wie schon in den letzten Jahren, bin ich auch dieses Jahr wieder mit dabei.
Mein Vortrag zum Thema "SVG in APEX
" findet am Mittoch dem 16.11. um 13:00 Uhr statt.
Den Vortrag halte ich nicht allein. Sebastian Reinig
ein sehr talentierter junger APEX-Consultant hält den Vortrag mit mir Zusammen. Sebastian hat (more...)
Back in 2010 I wrote about a solution for IE only: Open Windows directory with APEX (IE only)
The request itself appears at least once a year in one of my projects.
Nowadays I do not propose the workaround from 2010. It just doesn't fit in modern browsers.
Today I got another request to open a directory and this time I searched for 10 minutes and found a suitable solution working in IE, Firefox and (more...)
for a while now. It is an amazing plugin to create all kind of customized business solutions. But before I show you how I have used Raphaël I tell you how I came to the technology and what happened in the last few years. (more...)
In my summer holiday, this year in Stockholm (Sweden), I will make a stop and present two APEX topics in the "Stockholm Oracle Meetup group".
The topics will be:Working with interactive SVG graphics in APEX
Adding SVG graphics inside individual business applications is quite in common. Because those graphics can increase the usability and even more important it creates a completely new way to visualize data inside a browser app. In this presentation he (more...)
Most of you know the default APEX edit icons you can choose from inside your Interactive Report.
Basically you use them to link to a detail page.
The icon source looks like this.
A typical result page.
Two things I would like to change:
1. The Icon should be a nice looking car symbol from the Font Awesome library.
2. The column width should be as small as the icon and not relative to the (more...)
Resetting an Interactive Report (IR) can be done in 4 different ways.
User Reset, URL Link, Page Process, Dynamic ActionFirst of all
It is always a good start to set up a specific static report id.1. User Reset
Not much to say.
1. URL Linkf?p=&APP_ID.:1:&APP_SESSION.:::RIR,CIR:
- RIR: reset IR to primary report
- CIR: reset IR to primary report but with custom columns (more...)
Vor kurzem musste ich Daten aus einer Excel-Liste in das SDO_GEOMETRY Format bringen. Leider hatte die Excelliste einen Haken.
- Es musste eine Linie (Typ 2002) im GK3 Format (31467) aus VON und NACH Punkten generiert werden.
- Die Excel-Liste hatte die Punkte entweder als GK3
oder als WGS84
Nach Import der Daten sah meine Quelltabelle dann so aus:
Und hier das Select zur richtigen Transformation der Geo-Daten ins SDO_GEOMETRY Format:
Since APEX 5 it is much easier to create master-detail pages with modal dialogs. But there is still no declarative way to create a conditional row based column link.
This blog post will show you a way how to create a conditional row based master - detail page.
1. We need some sample data:
WITH MY_DATA AS
select 1 as ID, 'APEX Connect' as name, 1 as CONDITIONAL_COL from DUAL
select 2 (more...)
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be automatically trimmed if more then 60 characters were displayed. If the user moved the mouse above a trimmed comment then a tooltip should be display including all comment text.
My first idea was to check for existing plugins which could do this job for me. So I searched (more...)