May 6, 2020 | Analytics, Episode 2
The ability to embed your analytics from Oracle Analytics Cloud (OAC) is useful in a number of scenarios including the creation of custom applications that re-use analytics from OACas well as the integration of OAC analytics in your own websites. This session will...
May 6, 2020 | Analytics, Episode 2
Someone’s stealing money from the Iron Bank! After a series of fraudulent transactions, a huge sum of cash is missing.But who’s the culprit?This session will show you how to use SQL to implement simple rules-based analysis. It’ll then show you how to use...
May 6, 2020 | Analytics, Episode 2
Most analytics professionals sooner or later touch one part or another of Oracle Analytics Security but almost never mange to acquaint themselves with every single aspect of it. With the advent of the cloud vs on-premises split of the product line the topic has become...
May 5, 2020 | Database, Episode 2
Is it a no-brainer for a DBA to prevent unwanted connections to an Oracle database ?In the form of a discussion, Martin and Flora address important organizational and technical issues regarding this topic.How to grasp the business needs concerning access policies ?...
May 5, 2020 | Database, Episode 2
Today, the choice of the database technology is in the hands of the developers, and Open Source alternatives look appealing. Many talks and papers show the growing features of MySQL or PostgreSQL, which competes with the commercial RDBMS. But do not forget the core...
May 5, 2020 | Database, Episode 2
When you write SQL, Oracle runs it through the Optimiser to determine the fastest way to access the data.This access path sometimes changes without anyone noticing.Sometimes it’s faster.Sometimes it’s slower. Dramatically, catastrophically slower.Why doesn’t Oracle...
May 5, 2020 | Database, Episode 2
The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused?The aim of this...
May 4, 2020 | APEX, Episode 2
The fabe team is building an app to help people stop climate change and human-caused extinctions by following a new 3Rs for the 21st century: reduce consumption, rescue species, and reconnect with nature. The team is all volunteer and distributed across the globe. We...
May 4, 2020 | APEX, Episode 2
Time to validate your APEX validation processes: Are you always validating client side and server side? Are you using the most efficient validation options? Are you up to speed on interactive grid validation options, single and multi-row? Are your validations firing...
May 4, 2020 | APEX, Episode 2
Part of the Oracle database since Oracle8, Oracle have discontinued Oracle Multimedia as of Oracle 19c. This leaves existing customers with a dilemma, either keep their multimedia on 18c and put off the inevitable for as long as possible, or find another solution for...
May 4, 2020 | APEX, Episode 2
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...
