Donnerstag, 25. Februar 2021

Oracle Autonomous DB (Oracle cloud) - Sending Email from APEX (not for free)

Viele experimentieren schon mit APEX innerhalb der Oracle Cloud ADB (ALWAYS FREE...) - aber so ganz FREE ist es dann doch nicht.

Chaitanya Koratamaddi, Oracle product Manager, beschreibt in seinem Post vom 2. Februar 2020, wie APEX_MAIL aufgesetzt wird... hier der Link zum Post.

Genutzt wird dazu das neue APEX Feature "Automation" (unter shared compoments).

Aber: zu Anfang heißt es auch in der 


  • The instructions in this blog post use the free promotion account that is within the trial period. When your trial is over, your account will be limited to Always Free resources. You need to upgrade to a paid account to continue to use the Email Delivery. 
Schade eigentlich....

Ein "Workaround" scheint zu sein - wenn man APEX_MAIL nutzen möchte, sich für wenige Cents einige Cloud Services dazuzukaufen....

Allerdings blicke ich bei der Oracle Preispolitik für die Cloud und ADB nicht durch... welcher Service das sein könnte...

Ich recherchiere mal....wenn ich mehr weiß, werde ich es hier schreiben...

Freitag, 5. Februar 2021

APEX 20.2: DBMS_SCHEDULER becomes "APEX Automation"

sorry for crossposting ! - but I found this extremely interesting and helpful:

Oracle PM Salim Hlayel writes about the new "Automation"-feature  - based on the DBMS_SCHEDULER:

check it out !!!

Good luck ! 

Jasper Reports Studio - Print when expression used for subreport

Environment: JR Studio 6.1.1 - APEX 20.2

I have one main report with 3 subreports and I like to print certain subreports depending on certain conditions.

My Main Report looks like:

In the detail bands 1,2,3 you see my SubReports A,B,C

within my sql query for the mainreport I put a case condition like:

   when HV_ABRECHNUNG.TAGE_ANTEILIG > 0 then 'Ja' else 'Nein'
end PRINT_Anteilig,  .....

For development and control purposes I put the result into a field marked (1). Later I delete this.

Then I used the "PRINT WHEN EXPRESSION in Jasper Reports Studio for the detail bands B and C (not to the subreport !!!).

You'll find these under Properties --> Appearance ... (click on the edit pencil):


new Boolean($F{PRINT_ANTEILIG}.equals("Ja"))

So this I applied to detail band 3 or C

and for detail band 2 or B I put in the expression editor:

new Boolean($F{PRINT_ANTEILIG}.equals("Nein"))

Good luck !!

Montag, 8. Juni 2020

Virtual Hands-on Lab Autonomous Database for APEX Developers June 16+18 2020

Virtual Hands-on Lab Autonomous Database for APEX Developers Part I and II wird es 16 und 18. Jui 2020 geben...

 Moderator: Bo English-Wiczling
Director of Program Management

 You'll learn hands-on how you can extend your APEX applications with new functionality by leveraging the new features that the Autonomous Database brings.
 Think about MACHINE LEARNING (including theory),
geographical visualizations with SPATIAL,
security and self service visualization with ANALYTICS.

 We'll go straight into these exciting topics and you'll be doing a lot of coding yourself in the exercises.

 Participants will get access to an Oracle Cloud account.
 Part I
Scheduled Labs 16th June:
- Lab 100: First steps with ATP
- Lab 200: Add Spatial to your APEX app
- Lab 300: Add Machine Learning to your APEX app

Part 2 Scheduled Labs 18th June:
- Lab 400: Add Security to your APEX app
- Lab 500: Add Analytics to your APEX app

Link zum Hands-on-Lab

 Viel Spaß !!!

Freitag, 24. April 2020

The making of COVID19.ORACLE.COM

COVID19.ORACLE.COM ist ein "Therapeutic learning System" und eine vom Oracle APEX Team entwickelte Anwendung, in der Covid19 infizierte ihr tägliches Wohlbefinden mitteilen können.

Am Anfang der Covid19-Krise in den USA gab es seitens der US Regierung einen Aufruf an alle Firmen, ihr Know How und Resourcen zur Verfügung zu stellen: "As part of a general mobilization of the tech industry to provide apps, tools, and cloud compute capacity,..." (wortlich aus dem ZDNet Artikel) - wie es weiter ging und

Wie es zu der App kam....

Die Story aus dem Munde von Joel Kallman umso beeindruckender - innerhalb der APEX@HOME 24 hour session am 16.4.20.... aufgezeichnet hier (bzgl. des Covid19 Projektes ab Min. 08:30h) - für mich hörte sich dies wie ein guter Krimi an...

Es lohnt sich, das anzuhören....

Als die App fertig war, gab es dann ein Announcement im White House hier.

Demo Video:

Freitag, 10. April 2020

APEX@HOME - 24 hours virtual conference - 24 speakers 16.April 2020

Awesome event - awesome speakers... just join and have fun!! - Start: Do., 16. April 06:00h deutsche Zeit - also: früh aufstehen !!

Recordings will be available via this link.

Our awesome APEX community has gotten together to create a virtual one day conference called APEX@Home! This will be a 24hr event with 24 speakers starting at 00:01 EDT on April 16th going until 23:59 EDT. We will be using the APEX Office Hours platform and Zoom link to host the event.

The format of talks will be 45 min talk (starting on the hour) followed by a 10 min Q&A from participants. We’ll allow a 5 min change over to switch to the next speaker then continue with the next talk.

What do you need to do?

Subscribe at so you can receive reminders for this special event.

We’ve created a schedule of all the talks (in APEX of course) that includes calendar links so you can easily add all the talks you want to attend to your calendar.

Pass this info along to all your friends, colleagues, etc. Help spread the word!

A lot of people in the community have stepped up to make this event a success so let’s all #MOCA!

12:00 AM = 06:00h Berlin-Time

Wenn man "Add to calendar" klickt, werden die Termine zu konvertierten Zeit im eigenen Kalender eingetragen ... alles started Donnerstag, 15 April 06:00h - früh aufstehen!!!

Update 16.04.2020 - 08:00h - Start-/End Zeiten sind jetzt DE-Zeiten jetzt:

TBDShakeeb Rahman16-APR-2020 06:0016-APR-2020 07:00Add to Calendar
Database Design for APEX Devs in 45minHeli Helskyaho16-APR-2020 07:0016-APR-2020 08:00Add to Calendar
Database Links vs. REST Enabled SQL in APEXAndreea Munteanu16-APR-2020 08:0016-APR-2020 09:00Add to Calendar
Using the PL/SQL DebuggerPhilipp Salvisberg16-APR-2020 09:0016-APR-2020 10:00Add to Calendar
Wizard of ORDSRoel Hartman16-APR-2020 10:0016-APR-2020 11:00Add to Calendar
Know your Browser Dev Tools!Daniel Hochleitner16-APR-2020 11:0016-APR-2020 12:00Add to Calendar
The Ultimate Guide to APEX Plug-insStefan Dobre16-APR-2020 12:0016-APR-2020 13:00Add to Calendar
Keynote / APEX 20.1Joel Kallman / Marc Sewtz16-APR-2020 13:0016-APR-2020 14:00Add to Calendar
A dozen things to do with Oracle APEXScott Wesley16-APR-2020 14:0016-APR-2020 15:00Add to Calendar
Bring the Light into Your Always FREE Autonomous CloudDimitri Gielis16-APR-2020 15:0016-APR-2020 16:00Add to Calendar
Design Principles for Creating “Grrreat” APEX ApplicationsSimon Hunt16-APR-2020 16:0016-APR-2020 17:00Add to Calendar
APEX Debugging 101Peter Raganitsch16-APR-2020 17:0016-APR-2020 18:00Add to Calendar
APEX architecturesNiels de Bruijn16-APR-2020 18:0016-APR-2020 19:00Add to Calendar
Building Single Page Applications in APEXMatt Nolan16-APR-2020 19:0016-APR-2020 20:00Add to Calendar
APEX and the REST of the WorldCarsten Czarski16-APR-2020 20:0016-APR-2020 21:00Add to Calendar
Learning JavaScript Concepts from Real-World SolutionsDan McGhan16-APR-2020 21:0016-APR-2020 22:00Add to Calendar
APEX Security ChecklistScott Spendolini16-APR-2020 22:0016-APR-2020 23:00Add to Calendar
Advanced CSS/JS Techniques to Tweak You Application UIMaxime Tremblay16-APR-2020 23:0016-APR-2020 24:00Add to Calendar
Browser DevTools: The other tool for APEX DevelopmentJorge Rimblas17-APR-2020 00:0017-APR-2020 01:00Add to Calendar
You’ve Got Mail: Tips, Tricks, and Tools for Mail in Application ExpressTimothy St. Hilaire17-APR-2020 01:0017-APR-2020 02:00Add to Calendar
APEX developer's tools of the trade. Applications and tools to aid in application development.Tyson Jouglet17-APR-2020 02:00 PM17-APR-2020 03:00 PMAdd to Calendar
Top 10 tips to optimize APEX for mobileVincent Morneau17-APR-2020 03:0017-APR-2020 04:00Add to Calendar
Social Login while Social DistancingMartin D'Souza17-APR-2020 04:0017-APR-2020 05:00Add to Calendar
Great features of SQLConnor McDonald17-APR-2020 05:0017-APR-2020 06:00Add to Calendar