
DATE - First and Last day of a month
Simple task and simple solution: -- First day: select TRUNC(sysdate,'MON') as first_day from dual -- Alternative: select TO_DATE('01.'||TO_CHAR(SYSDATE,'MM.YYYY'),'DD.MM.YYYY')...
Simple task and simple solution: -- First day: select TRUNC(sysdate,'MON') as first_day from dual -- Alternative: select TO_DATE('01.'||TO_CHAR(SYSDATE,'MM.YYYY'),'DD.MM.YYYY')...
Ich habe in den letzten Tagen an einer Mini-Anwendung gearbeitet: "Cookie Applikation". Hintergrund: Die Verwendung von Cookies in APEX ist nicht kompliziert,...
Obwohl APEX 5 noch nicht erschienen ist, ist die APEX Community aktiver denn je. Hiermal eine Überischt der letzten Aktivitäten: Frankfurt - 23.02.2015...
In APEX you have the possibility to disable text fields. Unfortunatelly you can not submit those fields after the value was changed by a dynamic action...
We all know the regular expression syntax is fast and you can do amazing things with little code snippets. But we do know as well that whenever you need...
A couple of days ago a had a task to combine a list with itself. The result should be a two column report of each possible combination. What should...
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...