DOAG DEV TALK ZUM THEMA “JAVASCRIPT IN APEX?”

NEU: “DOAG Dev Talk”-Reihe

Thema: JavaScript in APEX?

Referenten: Kai Donato & Carolin Hagemann

Moderation: Niels de Bruijn, Leiter der Dev-Community

Einen Link zur Anmeldung stellen wir zeitnah zur Verfügung!

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT JÜRGEN SIEBEN

Beschreibung:

Die Schulung erläutert, wie in APEX schnell und komfortabel entwickelt werden kann, ohne die Anforderungen an eine saubere Anwendungsstruktur zu verletzen.

Eigentlich weiß es jeder: Software wird in Modulen entwickelt, die eine Schnittstelle und eine Implementierung haben und aufeinander aufbauen. Oracle empfiehlt dies, Technical Papers wie zu SmartDB oder PinkDB schlagen entsprechende Lösungen vor. Dennoch sind die meisten APEX-Anwendungen weit von einer sauberen Struktur und der damit verbundenen Erweiterungsfähigkeit und Wartbarkeit entfernt. Warum?

Ich bin überzeugt: Weil der Prozess nicht einmal vollständig durchdekliniert, erprobt und mit den entsprechenden Werkzeugen flankiert wurde. Da dieses Setup fehlt, erscheint es einfacher, eine einfache Anwendungsseite schnell und einfach mit den Assistenten zu erstellen, anstatt angeblich aufwändige Packages erstellen zu müssen. Dieses Seminar stellt eine Strategie vor, wie sauber programmiert werden kann, ohne auf APEX-Assistenten verzichten zu müssen. Zudem profitiert das Team durch eine bessere Aufteilung der Zuständigkeiten und eine höhere Parallelisierbarkeit der Programmierung.

Die eingesetzten Werkzeuge und Skripte stehen allen Teilnehmern kostenlos zur Verfügung.

Zielgruppe:

Fortgeschrittene APEX-Entwickler, aber auch Teamleiter von APEX Entwicklerteams, die eine leistungsfähige Strategie suchen, um komplexe Anforderungen mit APEX umsetzen zu können, ohne in ein Wartungsdesaster zu geraten.

Vorkenntnisse:

APEX-Kenntnisse sollten ebenso vorhanden sein wie solide SQL und PL/SQL- Kenntnisse

Welche Fähigkeiten erlangen die Teilnehmer:

Es wird eine Strategie erarbeitet, die jedem Teilnehmer die Möglichkeit gibt, im Team effizient und architektonisch sauber APEX-Anwendungen zu entwickeln. Zudem werden Strategien vermittelt, um die Entwicklung im Team zu unterstützen.

Die hierfür benötigten Werkzeuge werden vorgestellt und den Teilnehmern zur Verfügung gestellt.

Dozent:

Jürgen Sieben ist bereits mehrfach als Dozent der Expertenseminare aufgetreten, ebenso als Speaker auf der DOAG-Konferenz und der APEX Connect. Er verfügt über umfangreiche Schulungserfahrung im Umfeld von Oracle (> 1000 Schulungstage) und ist Experte für SQL, PL/SQL, APEX und allgemeine Oracle-Themen.

 

 

 

Die Anmeldmöglichkeit für Teilnehmer stellen wir asap zur Verfügung!

Wir freuen uns auf Ihre Teilnahme

APEX Em Português

O Oracle Application Express (APEX) é uma plataforma de desenvolvimento de baixo código que permite criar aplicativos escalonáveis ​​profissionais e seguros que podem ser implantados em qualquer lugar.apex

Junte-se aos desenvolvedores da comunidade e gerentes de produto da APEX para obter o máximo desta ferramenta incrível!

Automating APEX Applications Backup

Hi all,

As you might be aware and already posted by me here, o export APEX Applications the APEXExport Tool should be used.
Here we’ll also see some alternatives to accomplish that.

Plan A) Using same as discussed in the previous post for exporting all Applications in an instance:

As being, for any backup script, 3 parts need to be backed up

1. With database Export utilities (Datapump or Legacy Export, be aware of the limitations of each) dump your APEX applications need to run:

expdp matheusdba schemas=MY_APP_SCHEMA directory=DIR_BKP dumpfile=APEX_APP_SCHEMA.dmp logfile=APEX_APP_SCHEMA.log

2. Run the APEXExport using “-expWorkspace” to export all workspaces (This will generate a w*.sql script for each workspace)

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -expWorkspace

3. Run the APEXExport using “-instance” which will generate a f*.sql script for every application and shared component.

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -instance

Plan B) Take separate Backups for each Application or Workspace

Here is the interesting part: You can take also backups by applicationid or workspace id, with the following:

1. Exporting by ApplicationID:

APEXExport -db hostname:listenerport:dbservicename -user -password -applicationid 31500

2. Exporting by WorkspaceID:

APEXExport -db hostname:listenerport:dbservicename -user -password -workspaceid 9999

But how take all the workspace IDs? You can use the following SQL statement in SQLWORKSHOP:

select wwv_flow_api.get_security_group_id from dual;

Now you have all the basic exporting steps, it’s up to you to build the script as it fits better for you.

I hope it helps!

Additional notes:

  • The workspace export should export all of the shared components from the workspaces.
  • This does not mention RESTful services but if using the APEXExport from 4.2.4 or higher, they will be included.

Additional Reference:

  • APEXExport Gives: Java.lang.NoClassDefFoundError: Oracle/apex/APEXExport (Doc ID 2265534.1)

APEX Em Português

O Oracle Application Express (APEX) é uma plataforma de desenvolvimento de baixo código que permite criar aplicativos escalonáveis ​​profissionais e seguros que podem ser implantados em qualquer lugar.

Junte-se aos desenvolvedores da comunidade e gerentes de produto da APEX para obter o máximo desta ferramenta incrível!

Moving APEX Applications Repository

Hello,
Most likely you land here because you need to migrate APEX Applications/Workspaces from one database to another, correct? You are in the right place!

We’ll use the APEXExport for this end.

Here you have a quick summary of the steps to use the tool, assuming:

  • The source APEX instance is at least 4.2.4.
  • The target instance must be 4.2.4 or higher.

Also, be aware that the APEX installation (the APEX and FLOWS_FILES schemas) cannot be exported in this manner or in any other manner.
So the APEX itself must pre-exist, what we’ll do is migrate the workspaces from one installation to another.

To Export:

1. Use database Export utilities (Datapump or Legacy Export, be aware of the limitations of each) to generate a dumpfile with all DB objects and data that your APEX applications need to run.
This will normally be the objects in the schemas that your APEX workspaces are dependent upon.

2. Run the APEXExport twice as follows:

2.1 First run it using “-expWorkspace” to export all workspaces (This will generate a w*.sql script for each workspace)

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -expWorkspace

2.2 Now run it using “-instance” which will generate a f*.sql script for every application and shared component.

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -instance

Note that that workspace export should export all of the shared components from the workspaces.
Note that this does not mention RESTful services but if using the APEXExport from 4.2.4 or higher, they will be included.

To Import:

1. Import the dumpfile generated for the regular database schemas your APEX Application use.
2. Import the workspaces via sqlplus as per:
2.1 connect sys / as sysdba
2.2 alter session set current_schema = APEX_040200;
2.3 run the scripts to create the workspaces

@<script_generated>.sql

This will create the workspaces with the same workspace IDs as the source DB.
This also prevents the need to modify the workspace ID contained in each of the application exports.

3. From the same session as above, accomplish the import of each of the application exports.

SQL> @.sql 
SQL> @.sql [...] 
SQL> @.sql

I hope it helps!

APEX CONNECT 2021 [ONLINE]

Die APEX connect 2021 [online] heißt euch am 4. und 5. Mai zum großen Wiedersehen der Community willkommen – bequem und sicher von Zuhause oder dem Büro aus. Freut euch auf zahlreiche Vorträge und Workshops zu den Themen APEX, JavaScript und PL/SQL! Wir bieten euch ein einzigartiges Online-Konferenzerlebnis mit jeder Menge Wissensaustausch, Networking und einem unterhaltsamen Abendprogramm.

Low Code Development with Oracle APEX on Autonomous Database by Chaitanya Koratamaddi

Oracle APEX is the world’s most popular low-code application development platform for building and deploying modern data-driven applications. Business users and application developers can create enterprise apps 38X faster without having to learn complex web technologies. Gain hands on experience learning how the new APEX Service works to build a fully functional APEX app in less than an hour. Go from zero to hero in a ridiculously short period of time! This workshop includes two parts: Creating an App based on Existing Tables for Oracle Autonomous Cloud Services In this hands-on lab, you’ll learn how to quickly and easily build impressive apps on top of your existing data. Building an App using REST Data Sources for Oracle Autonomous Cloud Services In this hands-on lab, you learn how easy it is to build Oracle APEX apps utilizing RESTful Services. You learn how to create REST enabled database objects, and then use those REST endpoints as the basis for REST Data Sources within an application.

APEX Em Português – Office Hours

Na primeira sessão do APEX Em Português Office Hours, conheça e interaja com a comunidade APEX de língua portuguesa.
Teremos duas sessões:

– Por que o Oracle APEX é a melhor ferramenta?
Esta sessão apresentará uma visão geral da ferramenta Oracle Application Express que a torna diferenciada no mercado. Quais as principais características? Como utilizar? Por que utilizar? Como aprender mais? O que consigo fazer com o APEX?

– Casos de sucesso

Painelistas:
– Anderson Ferreira.
– Eduardo Kanashiro
– Leonardo Andrade

APEX Office Hours

APEX + Server-side JavaScript = Awesome!

Welcome to the future! Starting with Oracle Database 21c, developers can now execute JavaScript within the database. This functionality is enabled by the Multilingual Engine (MLE), powered by GraalVM. And APEX 20.2 is the first (and only) low code framework on the planet which natively supports server-side JavaScript, out of the box!

In this special edition of Oracle APEX Office Hours, we will be joined by Lucas Braun, Program Manager for GraalVM and part of the esteemed Oracle Labs team, and Stefan Dobre, who is a developer at FOEX AT and a respected luminary in the Oracle APEX community. They will:

1) Present MLE and what you can do with server-side JavaScript in APEX
2) Provide numerous real-world demonstrations
3) Show you everything you need to do so that you can try this yourself today, and for free in an Always Free Oracle Database