Mein Name ist Tobias Arnhold. Ich möchte Ihnen meine Fähigkeiten und Aktivitäten in der Community in diesem Post kurz aufzeigen. Weitere...
A new statement of direction is available for APEX 5.0: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-sod-087560.h...
I played a bit with tabular forms on views using an instead of trigger. After following the guide from Christian Rokitta I came really close to what...
Ich habe endlich etwas Zeit gefunden die Anwendung online zu bringen. Hier ist der Link: http://apex.oracle.com/pls/apex/f?p=65580 Aktuell arbeite...
Hallo Zusammen, im Zuge der letzten APEX SIG habe ich meine Pivot Anwendung als Packaged App fertiggestellt. Wer noch Interesse an einer Kopie hat, der...
$(".apexir_WORKSHEET_DATA").find("[headers='COLUMN_NAME']").hide(); $('#COLUMN_NAME').hide(); Why would you need this? In case the end user wants to...
After a lot of mails and requests I decided to create an example application and an extended documentation to each of the plugins. It will be published...
Nicht vergessen am 26.09 findet ein SIG Development Day zum Thema APEX statt. Mein Thema befasst sich mit APEX und Pivot Reports: Aktuell arbeite...
I don't know if this is a environment problem or a general one. Anyway it is mad and took me a long while to find out what it is. Here we go: -...
Wie berechne ich während der Laufzeit neue Werte und aktualisierte anschließend meine APEX Items. Die Lösung für diese Fragestellung ist recht einfach,...
This solution is based on the usage of Jasper Reports to create PDF reports inside APEX. You may had the requirement to create a PDF document with...
Viele von euch kennen bestimmt die Balken-Grafik die Ihr innerhalb eines APEX Reports erstellen könnt: Zu diesem Thema gibt es einige sehr gute Anleitungen: EN: http://www.inside-oracle-apex.com/more-undocumented-new-features-in-oracle-apex-31/#high_2...
APEX 4.2 will include the new "AnyChart Data Visualization Solution" based on HTML5. But in case you can't wait for it or search for an alternative then...
In vielen meiner Projekte nutze ich Tabular Forms. Bei Standardspalten wie "geändert am" oder "geändert von" ist es leider nicht ohne weiteres möglich...
Es gibt eine neue Version des Oracle SQL Developers: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Neben vielen...
Today I discovered a really cruel bug in APEX. We migrated an APEX 4.0 application into a new workspace with APEX 4.1. The application got a new application...
There is a easy way getting all APEX views just with a simple select: select apex_view_name, comments from apex_dictionary where column_id = 0 order...
A while ago I wrote about and development idea creating iReport (Jasper Report) PDF-files directly inside APEX (PL/SQL). Andreas Weiden the brain and...
I'm currently have some questions about TABULAR FORM validations. I my questions inside the APEX forum: https://forums.oracle.com/forums/thread.jspa?threadID=2407939 Questions: 1....
There is a quite easy way to generate nice looking Excel files based on your APEX reports. It doesn't require any special printing engine and should...
My default development client is the Oracle SQL Developer. If I compare it with TOAD it is slim, free to use and includes a table modeling area. One...
If you want to filter date values like this: Then extend the code to your date columns (inside the region source) like this: My date column...
If you look for workarounds when you reach the edge of the IN operator functionality then take a look here: http://www.williamrobertson.net/documents/comma-separated.html A...
This time I will present a solution for a character validation on the APEX item level. Normally you create a simple validation based on a REGULAR EXPRESSIONS...
/* 1. Standard sub query */ UPDATE tbl_employees x SET department = ( SELECT y.name ...
I'm currently working on a integration of the jQuery Real Person (Captcha) plugin into APEX. On the server side I had to execute a shift left. Which...
I really like the Label Cloud Plugin by Carsten Czarski but a customer complained that there are not so much visual differences by words when the occurences...
This is an example for the use of a simple cookie which gets created after submit when click on a button. Afterwards a region inside my page shouldn't...
Less then one week is left and only 4 plugins has made there way to the competition: http://www.apex-plugin.com/oracle-apex-plugins/odtug-competition.html That...
This is a simple example to validate an APEX item with regular expressions (on client side): v_text = $('#P1_MY_ITEM').val(); v_regex = /^[a-zA-Z0-9_...
If you want to beautify your number column inside an APEX report with a percent-sign then most of you would do like this: select column_name...
There is a easy way to set up your APEX workspace login URL so that you reach a special page inside your application builder. The following URL example...
There is a nice development going on to include the created IReport (from Jasper Reports) templates with a PL/SQL PDF Generator. For more information...
Um die Client-IP-Adresse mit Hilfe von PL/SQL auszulesen, können Sie zwei unterschiedliche Prozeduren verwenden: select owa_util.get_cgi_env('REMOTE_ADDR') from...