Application Express

Application Express at the ODTUG Kscope17 Conference

The ODTUG Kscope17 conference will prove to be the most in-depth, intuitive, and engaging conference for APEX developers. Across the globe, every business has a need for user-friendly applications. Kscope17 is the APEX conference of choice for app developers around the world.

Integration:

Learn how to make your applications fly as Oracle experts, ACE Directors, ACEs, ACE Associates, product managers and developers teach you everything they know about integrations with MS Office, using JavaScript. Develop and deploy responsive, secure, and database-driven applications using platforms, tools, databases, and other framework integrations.

New Release:

Learn from APEX developers as they discuss their experience and insights with the latest version of Application Express. You’ll learn about using Page Designer, Modal Pages, and the all-new Universal Theme options from the latest release. From interactive reports and grids to new features for pages, regions, lists, buttons, forms, and calendars, the new Universal Theme options are full of new functionality. 

Detail Plunge:

Looking to dig deep into the developer toolbox? Kscope17 will deliver a detail plunge into world-class content, created by developers presenting case studies, new technologies, and techniques.

Check out the presentations listed below.



APEX 5.1: The Smaller New Features You Can't Afford to Ignore
Dietmar Aust , Opal-Consulting
Topic: Application Express - Subtopic: New Release

With every new release of Oracle APEX, everybody talks about the major (so-called marquee) features such as Interactive Grids, Master/Detail/Detail, the new Charting Engine, and the enhancements to the Page Designer.

But aside from that, typically over 100 smaller enhancements have been added to the product that make our lives as APEX developers a lot easier and are really valuable to learn about; typically they are not talked about that much.

These features have been analyzed by talking with the APEX team and also by comparing the differences in the data model and APIs between version 5.1 and 5.0.

These smaller features include the new Proxy Authentication (with ORDS), the change in the architecture (moving to a JSON-based page rendering/submission that removes certain restrictions such as the number of items per page), javascript apis for notifications (apex.message), improvements in the modal dialogs, the javascript apis for the interactive grid, and many more.

Back to Top
Have You Sampled the Packaged Apps?
Paul Broughton , APEX Evangelists
Topic: Application Express - Subtopic: Other Application Express

APEX 5.1 has over 35 packaged applications, with many showing the very latest APEX enhancements. Many of these may be new to developers, and this presentation will discuss and demonstrate some these in use such as the Interactive Grid and Jet Charts. This presentation will dive into a number of packaged applications, looking for some of the most innovative and powerful features. It will demonstrate the basics such as simply installing and managing the packaged applications.

After demonstrating some of these unique features, the presentation will build real-life examples into custom APEX applications.

Back to Top
Going to the Grid: What the APEX 5.1 Interactive Grid Means for You and Your End Users
Karen Cannell , TH Technology
Topic: Application Express - Subtopic: New Release

The long-awaited APEX 5.1 Interactive Grid region is here – but what does it mean to you and your end users? Need some practical guidance on when, why, and how to adopt the Interactive Grid region type? This session is for those who have seen the introductory demonstrations, are looking to upgrade to APEX 5.1, and need some advice. Does the Interactive Grid replace Interactive Reports? No more Tabular Forms? This session answers practical functional and technical questions raised by this new region type:

• When and why should I upgrade existing regions to Interactive Grid?
• Is there an upgrade wizard?
• What features will I gain; what features will I lose?
• What about customizations – will they upgrade?
• How does an editable Interactive Grid compare to my existing tabular form?
• Which features must still be manually written? Do I still need to write all that collection logic?
• How can I customize appearance?
• How can I add dynamic actions?
• Can I extend the Interactive Grid functionality?
• Will my end users like it? What about data entry users?
This session compares and contrasts Interactive Grids with the Interactive Reports and tabular forms we are familiar with. We will pay particular attention to maintaining or replacing features and common customizations in existing applications: checkboxes, 32K limits, cascading select lists, row-level validations, interactions between columns, and navigation between fields. How does the Interactive Grid region measure up? Should you upgrade all your Interactive Reports and tabular forms now?

Attend and find out.

Back to Top
Securing Oracle APEX: Cross-Site Scripting
Nathan Catlow , Recx Ltd
Topic: Application Express - Subtopic: Other Application Express

Understanding the areas in Oracle APEX that typically result in security problems is essential to building robust solutions. This talk will take an in-depth look at cross-site scripting, undoubtedly the most prolific problem facing APEX applications today. We will be demonstrating the security impact of insecure applications as well as required fixes based on real-world examples.

The power of cross-site scripting attacks are regularly underestimated. In this session, we will demonstrate complex cross-site scripting attacks against APEX applications and use API calls and item settings to ensure the data within your APEX applications remains secure.

Back to Top
Explore the APEX APIs
Martin D'Souza , Insum
Topic: Application Express - Subtopic: Other Application Express

Most developers new to APEX aren’t aware that APEX comes with a plethora of very powerful APIs for both PL/SQL and JavaScript. This presentation will highlight some of these APIs and explain how and when to use them to speed up and simplify developing your APEX applications. New 5.1 APIs will also be discussed.

Back to Top
Getting Your Grips on Excel Chaos
Niels de Bruijn , MT AG
Topic: Application Express - Subtopic: Real World

If historically grown Excel mess in your company sounds familiar to you, then this session is for you. Based on real-world projects, learn how APEX can save end users a lot of time, how the migration is done, and what the strengths/weaknesses of APEX are, as opposed to Excel.

Back to Top
This Is How We Do It
Niels de Bruijn , MT AG
Topic: Application Express - Subtopic: Real World

Different kinds of APEX projects lead to different implementation techniques. Let us classify the project types we had in the past and how we dealt with them, not only from an implementation standpoint but also in how we interacted with our customer.

Back to Top
Managing Node.js Instances with Oracle APEX
Kai Donato , MT AG
Topic: Application Express - Subtopic: Integration

You want to monitor and manage your Node.js instances using a tool you are already familiar with? One of the most famous frameworks for controlling Node.js instances will be shown integrated in Oracle Application Express. I will show you how to create, manage, and monitor your Node.js instances from an Oracle APEX application.

Back to Top
Professional JavaScript Error: Logging for Oracle APEX
Kai Donato , MT AG
Topic: Application Express - Subtopic: Integration

Are you searching for the missing piece to perform a perfect start for developing with JavaScript in Oracle APEX? This is the right session for you.

You might be familiar with the built-in debugging features in Oracle APEX and searching for a way to debug JavaScript in a similar way. I will show you how I'm setting up my environment and how I enabled my applications to report all errors to the database instead of just printing it in the local browser console.

With this approach, we are able to create additional metrics for loading times and even specific function execution times. The best part of it: We are saving them to the database and show it in an additional analytics application in Oracle APEX! Attend this session to be best prepared for any JavaScript-related work in Oracle APEX.

Back to Top
Performant Faceted Search Navigation in APEX with Oracle JET and PL/SQL Table Pipelines
Erik Espinoza , Viscosity North America
Co-presenter(s): Jason Canada, Viscosity North America
Topic: Application Express - Subtopic: Real World

Faceted navigation is arguably the most significant search innovation of the past decade. Leveraged by retail sites including Amazon, Home Depot, and Zappos, faceted search allows users to quickly narrow a massive result set by giving them guides (the facets) of the major groups of their results. In this session, we discuss both thick and thin ways of doing this, from enterprise applications such as Oracle Endeca to simple methods using PL/SQL pipelined functions. We show you a retail use case and PL/SQL faceted database search, APEX application, and Oracle JET extensions.

Back to Top
APEX for Beginners
Dimitri Gielis , APEX R&D
Topic: Application Express - Subtopic: Other Application Express

If you've heard about APEX but didn't play with it yet, or only played with it for a couple of weeks, this session is for you. My goal is to save you at least a month of searching and finding your way to build great APEX applications. I'll share how to get started, where the APEX sweet spot is, and common pitfalls you should avoid.

Back to Top
OMG! JavaScript Straight from the Oracle Database
Dimitri Gielis , APEX R&D
Topic: Application Express - Subtopic: Integration

When APEX and the core database features were not enough, I started to investigate how to run JavaScript straight from the database. My results were baffling – and I want to share them with you. I'll explain how you can do it yourself and show many live demos where this new technique is useful.

Back to Top
Docker for Dummies
Roel Hartman , APEX Consulting
Topic: Application Express - Subtopic: Real World

You might (or might not) have heard of Docker, but you have no idea what it is and why you should care. But if you are a Database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session, you'll learn what Docker is and how you can benefit from it in your daily work.

Back to Top
Make Your APEX Applications Fly Using JET Components
Roel Hartman , APEX Consulting
Topic: Application Express - Subtopic: Integration

At Oracle OpenWorld 2015, Oracle introduced JET: JavaScript Extension Toolkit. APEX 5.1 ships with JET and uses it to create the good-looking charts declaratively. But if you know JET a bit better, you can tune the look and feel of the charts even more. And apart from the exposed charts, there are more components in JET you can use in your APEX application. This session will show you how to do that and walk through a way to create plugins for JET components.

Back to Top
Know What Your Code Is Doing; Know What It's Done: How to Instrument Your Code Easily and Effectively
Sabine Heimsath , its-people GmbH
Topic: Application Express - Subtopic: Detail Plunge

Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running?

This session is all about instrumenting your PL/SQL code, be it inside an APEX application or in a pure PL/SQL environment. What are the alternatives to the very common hand-knitted or organically grown solutions? We are going to look at a few open-source frameworks and analyze which requirements they can cover and what you might have to add yourself. After this session, you will know what to look for when choosing the right framework to enhance your project.

Back to Top
Plugin Your APEX Widgets
Menno Hoogendijk , Qualogy
Topic: Application Express - Subtopic: Detail Plunge

APEX 5.1 includes a lot of jQuery widgets and plugins under the hood. Because the development team uses them to create our beloved components as the Interactive Report and Interactive Grid, why not use the technique ourselves?

This session will demonstrate why widgets and plugins are so powerful. Did you know they can be exposed as APEX plugins to reuse them declarative? We'll explore how some of the existing widgets work in order to build our own, step by step.

Back to Top
Powerful JavaScript Skills for Every APEX Developer
Menno Hoogendijk , Qualogy
Topic: Application Express - Subtopic: Other Application Express

Are you a developer looking for steady JavaScript skills? We all have to deal with the same issues sooner or later. Knowing about the most common features will help you solve issues and create advanced applications.

We'll go over a lot of topics live: fundamentals, bad practices, their improvements, and new features. The result? End up with professional, organized code.

This session is intended for beginner and intermediate developers. Join my talk and get a better understanding about the ever-changing JavaScript landscape.

Back to Top
How to Use APEX to Build and Manage Automated Browser Tests
Simon Hunt , MOD
Topic: Application Express - Subtopic: Other Application Express

In this session, delegates will learn how to use APEX itself to build maintainable browser-based automation scripts for fast, consistent, repeatable testing of APEX applications. All the products demonstrated are available through open-source projects, and there is no need for any specialist programming skills other than APEX. Also covered is the ability to call the automation scripts programmatically and run them on a load testing environment or as part of an automated build process (AKA Continuous Integration). The techniques shown will help developers become more Agile in their development and greatly improve the overall quality of their applications.

Back to Top
Event-Driven Applications Using Custom JS Events
Tyson Jouglet , SkillBuilders
Topic: Application Express - Subtopic: Real World

Have you ever wanted to have the same dynamic action fire for different events, if the user clicks a button or if she presses enter? Out of the box, it appears that APEX cannot handle this situation. There is a very simple solution using custom events and event emitters in JavaScript.

Back to Top
APEX Generator: The Clone Wars
Moritz Klein , MT AG
Topic: Application Express - Subtopic: Real World

Want to see how you can build 120 fully functional APEX pages in under five minutes? Just rebuild them if the data model changed in the same time? Then this session is for you! See the APEX Generator in action and learn how to use the Data Dictionary and APEX Views to automate APEX page creation.

Back to Top
Mastering Universal Theme with Corporate Design from Union Investment
Oliver Lemm , MT AG
Topic: Application Express - Subtopic: Real World

You want to migrate to APEX 5 and the Universal Theme but, until today, you've only seen a few trivial presentations? Furthermore, you want to integrate your's or your customer's Corporate Design? In this presentation, you will get a bunch of knowledge which will help you to migrate to the Universal Theme. The APEX Application FondsProfiler was created in 2011 with APEX 4.1 and Theme 22.
The first step to the Universal Theme is to choose which old templates should be mapped to which templates from the Universal Theme. Then you have to make the choice between keeping the subscription to the Universal Theme and trying to make the design changes only with CSS, jQuery and some copied templates. Or you release the subscription and making changes easier now, but resulting in problems later when going to Universal Theme 1.x.
Another problem in many migrated applications is the big space between your items and the grid layout from the Universal Theme. You will get solutions how to arrange your items near to each other and still using Universal Theme templates.
Mastering design changes with theme roller, be aware of problems like !, important in your and theme roller's CSS. Having customized Tooltips, locking mechanism, or want to color your input fields based on the user's right - these questions will be answered in this presentation.
This presentation will be far more detailed than every other migration presentation you've heard before.

Back to Top
Uncover the Truth
Oliver Lemm , MT AG
Topic: Application Express - Subtopic: Real World

Got an old APEX Application to migrate or extend? Struggling by not knowing how complex the application is and which pages are full of customized code?
Furthermore, you might not know how the pages are related? Join this presentation to get fast answers for your most important questions. It will be presented how to identify which templates have been changed, how much CSS, JavaScript Code, and PL/SQL Code is hidden in your application pages. Even a tree view for the page navigation can be created automatically to understand how your pages are related.
With this information you can understand the application very fast and it’s much easier to make an effort analysis bringing new features to your application.

Back to Top
Creating an APEX Theme for Non-Designers
Vincent Morneau , Insum
Topic: Application Express - Subtopic: Integration

The fastest way to produce a beautiful application is by using APEX 5’s Universal Theme. The fastest way to customize that look and feel is by using Theme Roller. In a matter of hours you can have a unique design using built-in options only. But sometimes that simply won’t fit your client needs.

Not everyone can be a designer, write CSS, or is able to recognize a good design. That being said, I think every APEX developer has the skills to look at any online design and integrate it into APEX.

Integrating a theme is mostly about understanding how to properly copy/paste code in the designated sections of APEX and replacing the hard-coded content with APEX substitution strings.

This session will explain how you can use bits and pieces of an online design to create your own beautiful application. You should be able to ask your client to choose his/her preferred design through an online store and make your application look exactly like it.

Back to Top
Modern JavaScript in APEX: What to tTake and What to Leave
Vincent Morneau , Insum
Topic: Application Express - Subtopic: Detail Plunge

By now, JavaScript is inevitable for all APEX developers.

The rising popularity of JavaScript didn’t make everyone happy. There has rarely been a language that changes so much over time, making it hard to keep up with all the new tools and frameworks that emerge every now and then. This causes most APEX developers to stick to basic JavaScript functionalities.

This session will appeal to intermediate and advanced developers who wants to learn more about modern JavaScript but don’t know where to start.

Among a lot of extraneous tools and frameworks, there has been a few highly adopted standards. We will be exploring the usefulness of MVC Frameworks such as Angular and it’s alternatives like React. We will see how to write cleaner code with namespacing and promises. We will talk about using upcoming JavaScript features with ES6 and Babel and we will look into modularizing code with Browserify.

This session is a go-around what’s available in JavaScript today and knowing what’s useful (or not) as an APEX developer.

Back to Top
APEX and the Thick Database Paradigm
Anton Nielsen , C2 Consulting, Inc.
Co-presenter(s): Richard Soule, C2 Consulting, Inc.
Topic: Application Express - Subtopic: Detail Plunge

The "thick database" concept relies on encapsulating business logic into a pl/sql layer and isolating the presentation layer by providing access only to the pl/sql layer. Thick database benefits include improved adherence to business rules, enhanced security, and improved performance. This approach is often discussed in relationship to Java, Pearl and other mid-tier centric development tools. APEX applications reside in the database, but they benefit from the thick database paradigm as well. This presentation will provide best practices and real-world considerations for thick database implementation within the APEX development realm.

Back to Top
Unlocking the Power of the APEX Plugin Architecture
Matt Nolan , FOEX GmbH
Topic: Application Express - Subtopic: Integration

In this session you will get an in-depth look into the APEX plugin architecture using a real world example where performance is critical and the techniques used to optimize performance.

We will explore the best practices when it comes to designing plugins, event usage, increasing code centralization, and decreasing maintenance while plugging the functionality gaps in your APEX applications.

Back to Top
Life After Forms: The Move to APEX
Alex Nuijten , allAPEX
Topic: Application Express - Subtopic: Real World

Companies struggle with the question: Should we move to APEX when the time has come to let go of Oracle Forms?
This session will tell the story of a migration project where the Oracle Forms application needed to be replaced with an APEX application. What could we have done better? What are the lessons learned? What was the best choice that we made during this project? Not from the books, but from experience.

Back to Top
APEX Plugins That I Use in Every Project
Bartosz Ostrowski , Pretius
Topic: Application Express - Subtopic: Real World

Thanks to APEX architecture we - the developers - can create advanced and reusable components called plugins. Ingenuity and creativity of developers results in many free and handy plugins that save time, enhance application, and show that APEX is not just a collection of basic charts and reports.

During this presentation I will talk about APEX plugins that I use in big commercial projects. I will show how you can extend your application and add today's features that are listed in the APEX roadmap for tomorrow.

Back to Top
jQuery Widgets in APEX
Tom Petrus , iAdvise
Topic: Application Express - Subtopic: Detail Plunge

In our everyday APEX life, we're using many items and regions, which have a lot of settings. What you may not have realized yet is that many of the implementations are done through jQuery widgets. Sometimes direct, sometimes inderect through a namespaced wrapper. At times, it's very interesting to know what's actually under the hood and how and why things happen. Maybe there are some things that can even be influenced or altered.
In this session, we'll be taking a look at some of the widgets which APEX implements, or in some cases, have been created by the APEX team. We'll see how they function and how they can be manipulated or expanded upon.

Back to Top
Building in Blocks
Adrian Png , Insum
Topic: Application Express - Subtopic: Real World

Communications is an integral tool for building communities. The team behind apex.world wanted an effective communication platform for members to interact, and were confronted with the decision to build or integrate. Find out how popular products like MailChimp and Slack were integrated with the apex.world portal. Learn about the challenges faced by the team and how they were solved with some help from the same community for which that the portal was built. Take home tips and tricks that you can use in your projects!

Back to Top
Capturing and Manipulating Images with APEX and More!
Adrian Png , Insum
Topic: Application Express - Subtopic: Real World

A picture is worth a thousand words. It is common to receive project requirements that include image capture, manipulation, or both. We can opt to manipulate captured images either on the client-side using JavaScript or server-side using Oracle Multimedia. This session will examine the various methods and approaches for implementing an image manipulation solution with APEX. We will also look at computer vision and how to integrate this cutting-edge technology in your applications to make users say, "WOW!"

Back to Top
Finally Understand How APEX Works
Peter Raganitsch , FOEX GmbH
Topic: Application Express - Subtopic: Detail Plunge

I know, I know, you already used APEX and have built some fine applications. But do you really understand how APEX works and why it behaves as it does?

Have you ever just tried different things until finally something seemed to work, without actually understanding the what and the why?

Let me try to explain the basics of APEX: the foundation on that all fancy components (IR, Grid, Charts, ...) build up on.

After this session you should be able to understand all the important things: session state, communication, bad and good AJAX calls, and much more.

Back to Top
Let APEX Access Your Computer
Peter Raganitsch , FOEX GmbH
Topic: Application Express - Subtopic: Integration

Web applications are awesome, easy to access from anywhere, but also limited in what they can do. All of that happens for security reasons, of course, and that makes us accept that browser apps (like APEX) can't access any client resources like the filesystem, a printer, or a scanner.

Using the open source Electron project we can build a custom browser, to work around those limitations and extend our APEX applications to do what they need to do.

In this session we will look at what Electron is, how to set it up, and what possibilities there are.

There will also be some easy-to-use prebuilt examples for you to use after the session.

Back to Top
Deliver a Knockout with Your APEX Applications
Jorge Rimblas , Insum Solutions
Topic: Application Express - Subtopic: Integration

KnockoutJS provides two-way data binding between JavaScript and DOM elements and it's also the foundation for OracleJET. Whether you use OracleJET or not, KnockoutJS can deliver more pizzazz to your APEX pages. If you often feel your Dynamic Actions are getting too complex, or they are one line of code away from disaster, this session is for you. Come and get a short KnockoutJS tutorial and learn how to integrate it with APEX.

Back to Top
JavaScript and CSS for PL/SQL Developers
Jorge Rimblas , Insum Solutions
Topic: Application Express - Subtopic: Integration

If you have been working with the Oracle Database for a while, but still feel lost when working with JavaScript and CSS in your APEX applications, then this session is for you. Working with HTML, JavaScript, and CSS doesn't have to be hard. Learn about CSS selectors, what is the DOM and working with it, JavaScript functions, and even some jQuery. This session will provide you some tools to work better with web technologies.

Back to Top
Browser Developer Tool Essentials for APEX Developers
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
Topic: Application Express - Subtopic: Detail Plunge

If you are an APEX developer, you do use a browser to create applications that do run in a browser. Thus the browser is one of your primary tools. When you are developing in SQL or PL/SQL, your IDE (SQL Developer, TOAD, PLSQL Developer, …) offer you lots of functionality to support your work and enhance productivity. But building web applications, development is not limited to database objects. Suddenly you need to work with HTML, CSS, and JavaScript. Although APEX is doing a great job in hiding this complexity with a declarative approach, the more you develop with APEX, the more you will get into these techniques. Suddenly, you will need your browser beyond it’s rendering capabilities, and indeed, modern browsers are more like an IDE nowadays.
Debugging, testing, performance tuning, these are just a few aspects that you can do with your browser. This presentation will go through the latest techniques and features that browsers have to offer for us (APEX) developers, things you should know and use.

Back to Top
Hitchhiker’s Guide to the Universal Theme
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
Topic: Application Express - Subtopic: Other Application Express

When APEX 5.0 was released, it came with an entirely new theme: The Universal Theme. This theme impressively showcased several new features that where built into this new Application Express release: Themestyles, Template Options, Themeroller. These features, and how these are leveraged by the Universal Theme, made building a modern UI much easier and enhanced the User Experience of APEX applications. All an APEX developer must know is how to use these declarative features. So, let’s have a look at these in detail and the state of Universal Theme in APEX 5.1.

But with declarativity comes limitation, and for someone familiar with CSS, Themeroller is “Mostly Harmless." Using the Universal Theme as a standard, the “Answer to Life, Universe and Everything …”: 42, eventually all APEX applications will somewhat look similar. So, what about customizing Universal Theme to really fit your design needs? Well, it’s not that easy, but possible. I’ll show(case) some options.

Back to Top
Natural Language Voice Interface to the Oracle Database
Christoph Ruepprich , Accenture Enkitec Group
Topic: Application Express - Subtopic: Real World

Natural language voice interfaces have become quite popular, especially with mobile devices. Apple's Siri and Google's "OK Google" have come quite a long way, and are very good at interpreting the human language. A relatively new player on the marked is Amazon's Echo, a standalone speaker that accepts voice commands and questions, searches for answers on line, and answers back in a human voice.
The technology behind the Echo is Amazon's Alexa API. This API is available for developers to create their own natural voice interfaces.
We are going to explore how we can use the Alexa API to access an Oracle database to perform spoken inquiries like "How much does Miller earn?", "Who works in the research department?", or "Who earned the highest commission in sales?"
The results will not only be spoken back to the user, but can also be displayed in the Alexa mobile app as well as in APEX.
There will be a live demo of asking questions to an Amazon Echo device, and have it answer with data queried from the database.
A basic understanding of JavaScript and PL/SQL will be beneficial to the participants.

Back to Top
#LetsWreckThisTogether APEX Talks
Topic: Application Express - Subtopic: Detail Plunge

Just in case you have not received enough inspiring content by the end of the week, the #LetsWreckThisTogether APEX Talks is back. At last year's Kscope, this exciting new format was a success.

Instead of long, in-depth "deep dives" on a single topic. The APEX track of the conference will close with Lightning Talks presented by some of the best and well-known speakers and personalities in the APEX world.

The exact lineup will be announced closer to the event.

Back to Top
High Performance APEX (Or Don't Keep the Users Waiting)
John Scott , APEX Evangelists
Topic: Application Express - Subtopic: Real World

Whether you need to support 10 users or 1000 users, its important to understand how your application performs. In this session, I will cover the entire stack performance and show how you can debug which area of your APEX application is causing the bottleneck.

Back to Top
Oracle APEX - NLP, AI, and Bot Integration
John Scott , APEX Evangelists
Topic: Application Express - Subtopic: Integration

Natural Language Processing (NLP), combined with AI, and Bots are hot topics right now. In this session we will cover exactly how you can integrate these technologies into your APEX applications to really make your APEX applications user friendly.

Back to Top
From APEX App to Apple App Store – Simple Steps for Successful Submission
Stephen Smith , CampaignShortCuts
Co-presenter(s): Roel Hartman, APEX Consulting
Topic: Application Express - Subtopic: Real World

Want to learn how to prepare your APEX app for successful submission to the Apple App Store? This session will show you how to program the needed requirements and navigate the process steps to publish your app in the App Store.

Back to Top
GET POST ORDS JSON: Web Services for APEX Decoded
Scott Spendolini , Sumner Technologies
Topic: Application Express - Subtopic: Real World

Web Services in the APEX world are becoming more and more popular. However, there is still a lot of confusion as to what they are and how they could benefit the APEX developer. After a review of the syntax and jargon associated with web services, this session will review and boil down web services to their basic components. It will then demonstrate how APEX developers can start to use these powerful components - both to send and receive data from other sites.

Back to Top
Secure Your APEX Applications with APEX-SERT
Scott Spendolini , Sumner Technologies
Topic: Application Express - Subtopic: Real World

Application security is at the forefront of IT and will remain there for a long time. Thus, it important to consider security on day one of your application’s development. APEX-SERT is an open-source tool built in APEX that is designed to help evaluate your APEX applications for potential security issues. Not only will it identify them, but it will also offer advice on how to remedy them. APEX-SERT also offers the ability to create and approve exceptions in the case of either a false positive or an issue that is mitigated outside of APEX.

Back to Top
APEX Localization
Topic: Application Express - Subtopic: Real World

Terms "translation" and "localization" are often used interchangeably, while the differences are quite significant. If we want to create professional international application we must not only care about language, but also about elements that appeal to regional or cultural preferences including text direction, formats, calendars etc.
During this presentation I will show:
- how localization process works
- how you can cover it in APEX using built-in features, plugins and open source projects like OraOpenSource and translate-apex.com
- how you can use good practice from video game industry to create international APEX applications

Back to Top
Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, a Pizza Box, a Raspberry PI, Apex, JET, and the Oracle IOT Cloud
Jerry Ward , Viscosity North America
Co-presenter(s): Paul Hicks, Kaminario
Topic: Application Express - Subtopic: Integration

In this session we “science the #$%!”* out of a Raspberry Pi 3, Apex and the Oracle Internet of Things Cloud (*ref. The Martian Film). The Automatic Dependent Surveillance–Broadcast (ADS-B) is a precise satellite-based surveillance system that broadcasts real-time weather and uses GPS technology to determine any aircraft's location, airspeed, other date, and relays that data to air traffic control, aircraft, and to us because we are listening! We log and store this data in the Oracle IOT Cloud, then use Apex to build a simple application to view this data in real time and report on it over time.

Back to Top