
First impressions of developing an APEX plugin
After spending a couple of hours in building my first plugin. I came to the conclusion to create a plug-in which uses the UILayout technology. My first...
After spending a couple of hours in building my first plugin. I came to the conclusion to create a plug-in which uses the UILayout technology. My first...
It happened now two times that I wanted to update an IRR by a Dynamic Action. It just did not worked! The Dynamic Action fired (I saw that by debugging...
1. Das Item basiert auf dem JQuery Plugin: Autocomplete. Wenn Sie nähere Informationen zur Funktionsweise suchen, dann schauen Sie auf dieser Seite nach.2....
It gets time to start developing my first APEX Plugin. I thought first to develop an addon with the JQuery UI.Layout for APEX.Layout manager like ExtJS...
Sometimes images doesn't appear immediately (for example loading icons called before onSubmit processes). Especially new users who doesn't have these...
In der Entwicklung von APEX Anwendungen verwende ich ausschließlich den Firefox (FF) Browser. Zum abschließenden Test kommt dann der entsprechende Standard-Browser...
If you didn't know how you can easily select the current APEX version or the current APEX database user APEX_xxxxx. You can use these selects:-- Select...
Nach einer echt teuflischen Anreise die aus Stau, Baustellen und jeder menge Regen bestand, konnte der eigentliche DOAG Tag nur besser werden.Den ersten...
APEX Patch 4.0.2Laut Joel Kallman wurde die APEX Testinstanz apex.oracle.com auf Version 4.0.2 umgestellt. Das bedeutet das in wenigen Tagen/Wochen das...
Wer kennt es nicht:DECLARE v_text VARCHAR2 (2000);BEGIN v_text := 'insert into my_table (my_column) values (''Einfach zu ''''unübersichtlich''''!'')';...
For all those who hasn't noticed and those who are watching out for the current version of the Oracle HTTP Server. It is now part of the Oracle Web Tier...
Maybe you came in the situation when you created an APEX report and during your development you unfortunately saved it with the wrong selection.It happened...
Ich hatte ja vor nicht allzu langer Zeit schon erwähnt das ich ne Tooltip Anwendung erstellen wollte. Leider hat es die Zeit nicht ganz zugelassen.Seit...
Vor einer Weile wurde eine super Anleitung für die Verwendung von Dynamic Actions in APEX 4.0 auf der deutschen APEX Community Seite erstellt. http://www.oracle.com/webfolder/technetwork/de/community/apex/tipps/apex40-dynamicactions/index.html Damit...
In den nächsten Wochen und Monaten habe ich vor ein paar wirklich nützliche APEX Erweiterungen vorzustellen. In Form von Anleitungen und Beispielapplikationen...
Falls ihr es noch nicht gehört habt, im Oktober 2010 geben Denes und Dietmar einen Oracle APEX 4.0 New Feature Kurs. Für alle die mehr Erfahren wollen,...
Viele Entwickler in APEX kennen das Problem professionelle gut strukturierte Reports zu entwickeln, deren Spaltenbreiten nicht über die gewünschten maximalen...
Often I use to much pl/sql code inside my APEX processes. As we all know it is just better using complex code inside packages. In case you got trouble...
There a couple of tooltip examples/HowTos for APEX available and it becomes time to get them all together: Paulo Vale's solution: http://apex.oracle.com/pls/otn/f?p=25110:5HowTo:...
Sometimes when I worked with Reports and special HTML objects I came across the problem to access different in-line html elements by javascript.This...
A while ago I wrote how to create your own Javascript buttons inside a region: http://apex-at-work.blogspot.com/2009/05/building-your-own-button-in-apex-region.htmlHere...
The following post is targeted towards a German audience, thus it is in German:Wie vor einer ganzen Weile versprochen habe ich es endlich geschafft ein...
I know it is not really new but it is always good to have an example just for the case you don't have all code in your head! :DColumn-Link:Link Text:...
I while ago I had an issue with the ExtJS tree. Somebody mentioned that not all parts of an ext tree node (for example the icons or the empty area) get...
To show last updated rows inside a report isn't as hard as it sounds.All you need is a time column which saves the insert date and some changes on your...
Most of you know how to get an HTML session value inside APEX: $x('P1_NAME').valueTo get the current value from a radio button use this APEX...
Internet Explorer is the only browser which can run executable files. I don't know any other browser which supports this feature. Of course there are...
Warning a user that the form has changed. - http://www.sumneva.com/apex/f?p=15000:1310:0::NO::P1310_TIP_ID:121Increasing the speed of APEX Collections...
There are a couple of ways getting the url within javascript:Netlobo.com - Get URL Parameters Using Javascriptmattwhite.me - Get URL Parameter in JavascriptIt's...
To fill selects to a specific amount of rows with blank rows. Just use the rownum connect by trick:-- select templateSELECT *FROM (SELECT rownum, test_col...
All you need to open a MS file system folder with APEX is this little javascript:Header part<script type="text/javascript">function fnc_window()...
I answered a question in the APEX forum about an automatic full screen mode for your APEX application.There are a couple of ways how you can achieve...
I got stuck on a problem with Interactive Reports. I wanted to build filters during the application runtime with AJAX. These filters should be created...
I found a great source how to prevent word break outs in <th> and <td> elements: Peter Bromberg's: FIREFOX / IE Word-Wrap, Word-Break, TABLES...
I had a real pain with the MS Internet Explorer and the javascript function String.charAt(Index)I wanted to update a string and checked each value. IE...
Did you ever want a report header grouped like this:Just add some html code into your report template > column headings > Before Column Heading:Important...
I couple of days ago I wrote about a way using AJAX based select lists in APEX.After some hints from Peter Raganitsch I tried the ApexLib Framework but...
The following post is targeted towards a German audience, thus it is in German:Anfang Februar habe ich über eine Oracle DB Monitoring Anwendung für die...
Update an APEX item dynamically with AJAX:// 1. Item: HTML Form Element Attributes:onChange="javascript:fnc_setValue('P1_VALUE')";// 2. Page: HTML Header<script...
After searching the Web I found a nice description from James Koopmann: Making a Connection from Oracle to SQL ServerThen I found a Metalink note: WIN...
I looked through the Web for a simple way using a select list with dynamic data exchange inside my APEX application. What I found was just amazing (Thanks...
I linked a MySQL table into an OracleXE database (Short How to) and discovered a really strange behavior. When I tried an usual select about the MySQL...
I searched for a smoother way building ExtJS trees in APEX and found a great post from Anja Hildebrandt: Nice trees with ExtJS (Erstellung eines ExtJS-Baums…)She...
Why German? I come from and live in Germany! ;DI haven't really provided lot's of APEX based information in German. This just has to change. What to...
If you want to send data from your APEX application to an external website (like PHP) through the POST method. You can use the following example:Add...
I came across a problem with line breaks inside my automatically generated csv export.It had to do with some field values which had some line breaks...
Just a short hint for those who wants to use the SQL Developer in an English environment.You have to edit the following file:<SQL_DEV_ROOT_PATH>\sqldeveloper\bin\sqldeveloper.confIt's...