Petek, 2. junij ⁽²⁶⁾

Welcome to the World of OPatch

Every DBA knows the small but important tool OPatch, which is mandatory for applying patches to an Oracle Home. Over the last years and versions, new tools, such as opatchauto, oplan or datapatch have been added, or features have been improved.

When using OPatch, the following questions often come up:

1. How exactly do I use these tools or when can I not use these tools?
2. How do I use Opatch to remove backups of old patches?
3. How do I use OPlan to patch my complete cluster?
4. How do I use datapatch to apply the changes to my databases?
5. ...

The presentation will answer all these questions and provide some deep dive information into OPatch. Newer features like for example out-of-place patching will also be part of the presentation. Additionally, pitfalls and how to overcome them will be shown.

Where it all comes together, secured payments with APEX

Every Oracle release new features are introduced, but when to use them? In this presentation we are not diving deep into one specific feature but make use of a few to implement a payment interface with Oracle APEX. You will see everything you need to know to build an interace like that. I will also share the difficulties you will encounter building an interface like this. So if you want to know more about a real life use case for authentication, REST communication, JSON in the database and Webhooks this presentation will certainly please you. I will use Mollie as a payment provider.

Why I love the APEX-LOV

'Choose an option', 'Mark your preference', 'Select your country' ...

Every web application we are using for booking our travels, for online banking, for placing online orders has at least one of these elements, has a list of choices.

A list of choices can be represented in APEX as a radio group or checkbox or select lists or popup LOV or shuttle.

Among these, the Popup LOV is the most complex component a developer can use for displaying a list of choices.

Join my session to learn more about it.

After a brief overview on every one of these item types, the talk will focus on the evolution of the Popup LOV, from the simple ones available in APEX 5.x to the mature ones available in APEX 23.1

How and where to define a LOV, are there any rules to follow, is it an advantage to define a LOV as a shared component, how dynamic a LOV can be, may I create dynamic actions associated with a LOV, does a LOV understand JavaScript?

This presentation aims to give answers to these questions.

The talk is addressed to not-so-experimented developers but even an advanced one might learn a trick or two.

Zaključek