ODTUG Kscope19 is unique in its offering of one full day—a choice of four symposiums—at no additional charge. Start your week of education with this year’s Sunday Symposium for your track. 

APEXDatabaseEPMOracle Analytics

Oracle Sunday Symposiums will be posted as content is available.


Fasten your seatbelts! ODTUG Kscope19 kicks off on Sunday with the APEX Symposium, and all presentations are done by the APEX Development Team itself. Learn about the exciting new features of APEX 19.1 straight from the horse's mouth. See what is on the roadmap for APEX 19 and beyond. The new slogan is: #MOCA—Make Oracle Cool Again. Come see, learn, and be amazed!

Room: 6C 

9:00 - 10:00 a.m.

APEX 19 New Features and Roadmap

Marc Sewtz, Oracle Corporation

Over the past year and a half, Oracle APEX has made tremendous strides in opening up the platform to external data sources. REST APIs and objects stored in external Oracle databases are now first-class citizens and can be seamlessly chosen as the data source of popular components, such as classic and interactive reports, Oracle JET charts, and calendars. With Oracle APEX 19.1, REST support has been extended to APEX form regions, allowing read and write access to remote data sources. And with APEX 19.2, this is being expanded to encompass interactive grids as well. New, powerful data loading capabilities, with support for native Excel files, modern, multi-column-enabled popup LOVs and a brand-new filter report component round out the set of new features customers can look forward to in 2019. In this session, we’ll showcase all of these exciting new features and discuss what’s in store for 2020 and beyond.

10:00 - 10:30 a.m. | Break

10:30 - 11:30 a.m.

REST Integration

Carsten Czarski, Oracle Corporation

The latest Application Express Release 19.1 takes its support for external data sources (REST Services and REST Enabled SQL) to the next level. Forms do now support REST services and REST Enabled SQL. Thus APEX allows you to create, report, chart, and form pages on REST services—all declarative and without manual coding.

This session introduces this new feature and shows how to build a form on an external REST API—all without manual PL/SQL coding. Tips and tricks for practical usage will wrap the session up.

11:30 a.m. - 12:30 p.m.

APEX 19 Oracle JET Charts

Hilary Farrell, Oracle Corporation

In this session, we'll delve into the charting features and functionality available in APEX 19, based on the data visualization components of Oracle JavaScript Extension Toolkit (Oracle JET).

This JavaScript charting solution is highly customizable, accessible, and interactive, and it incorporates automatic responsive design support.

Learn how to effectively communicate your app data through the use of our extensive range of chart types and declarative capabilities, and easily utilize the JET JavaScript APIs to further customize your charts.  

12:30 - 1:30 p.m. | Lunch


1:30 - 2:30 p.m.

Universal Theme Update

Shakeeb Rahman, Oracle Corporation

The Universal Theme aims to empower developers to build beautiful, responsive, accessible apps without requiring extensive knowledge of HTML, CSS or JavaScript. This session will walk you through what is possible with Universal Theme, new features in the latest release, and how you can make the most of it in a supportable manner.  Learn how you can take full advantage of the capabilities in Universal Theme to build compelling, world-class user experiences for all of your users.

2:30 - 3:00 | Break

3:00 - 4:00 p.m.

Enhanced Popup LOVs

John Snyders, Oracle Corporation

Multiple columns and much better performance are just some of the improvements made to the Popup LOV item. Come see what the new Popup LOV can do.

4:00 - 5:00 p.m.

Using APEX on the Autonomous Database Cloud Service

Chaitanya Koratamaddi, Oracle Corporation

Oracle Cloud provides a set of autonomous and customer-managed Oracle Database services available in flexible configurations to meet your needs, large or small, with the performance of dedicated hardware. This session provides steps in detail to set up and get started with Oracle APEX environment in Oracle Cloud Infrastructure (OCI). In this session, you learn how to:

    • Set up the most affordable Oracle APEX environment on OCI Compute with Oracle Database 18c XE
    • Install Oracle APEX on your OCI DBCS using tried and true (conventional) methods or modern Terraform templates
    • Get started with Oracle APEX in the Autonomous Database

You also learn how Oracle APEX enables you to seamlessly lift and shift apps to Oracle Database Cloud Services.


This year the database team here at Oracle is excited to bring to ODTUG Kscope an entire day of training on the core topics of interest to developers and really, ALL database professionals. You can expect more deep, fundamental knowledge of what makes the database work and less marketing or future-looking topics. The keyword here really is “training!” We'll cover design, SQL, PL/SQL, performance, and the tools you need to do your job.


Because we also want you to have fun on your day off, we’re bringing both knowledgeable AND entertaining speakers, and we’re incorporating a game show into the talks—you will get to show off your knowledge and win some fun prizes. But what we really hope you bring home to your workplace is a more valuable and productive YOU.

Room: 6A 

9:00 - 10:00 a.m.

Data Modeling FFS: Free, Fun, & SQL Developer

Jeff Smith, Oracle Corporation

It’s the one thing we can all agree that SHOULD be done, but it quickly becomes an afterthought. Here’s a reminder why the design phase is so important, AND a boot camp how-to for quickly adding it back to your design/build/maintain lifecycle.

10:00 - 10:30 a.m. | Break

10:30 - 11:30 a.m.

Beginner's Guide to the Oracle Optimizer

Maria Colgan, Oracle Corporation

If you are new to the world of the Oracle Database, dealing with or "taming" the query optimizer can seem like a very daunting task. It can feel like the internals of the Oracle optimizer are shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This session aims to dispel this myth once and for all by showing exactly how the optimizer comes up with plans it does and explaining what you can do to get the right plans straight out of the box.

11:30 a.m. - 11:55 a.m.

Declarative PL/SQL

Steven Feuerstein, Oracle Corporation

Minimize the code you write and make the most of what PL/SQL can do for you by relying on these declarative features of PL/SQL. From the cursor FOR loop to the new-to-18c qualified expressions, let PL/SQL do the heavy lifting.

12:00 - 1:00 p.m. | Lunch

1:00 - 1:25 p.m.

Exceptional PL/SQL

Steven Feuerstein, Oracle Corporation

A rapid-fire review of features that help you trap and manage exceptions, including SAVE EXCEPTIONS, LOG ERRORS, user-defined exceptions, and more.


1:30 - 2:30 p.m.

HELP, I Don't Really Get How SQL Works

Connor McDonald, Oracle Corporation

Well done! You've come up with the killer idea for 2019! You've got the best UI design anyone has ever seen! Your modern application ticks all the boxes—serverless, functional, Kubernetes, Kafka, microservices, API-based, the list goes on. It runs on every OS and every type of device! But unfortunately, all of this counts for absolutely NOTHING if your data access is slow or buggy. Better data access typically means understanding how SQL is processed by the database, and who has time for that? SQL can be hard to understand and sometimes totally hidden from view under an ORM. Let's peel back the covers to show how SQL is processed, how to avoid getting hacked, and how to get data back to your application in a snappy fashion.

2:30 - 3:00 | Break

3:00 - 4:00 p.m.

Database Game Show!

Connor McDonald, Oracle Corporation

Members of our studio audience will get to compete in a game led by our host, Maria, and her assistant, Connor, as they show off their knowledge of the database, with some exciting prizes up for grabs. 

4:00 - 5:00 p.m.

REST APIs for Your Application PL/SQL and Data

Blaine Carter, Oracle Corporation

Now that you have your well designed, performant, and robust application schema ready to deploy, we will show you how to publish REST APIs to make it available to your web apps and/or automated processes using Oracle REST Data Services.


Oracle Enterprise Performance Management Cloud momentum continues to be adopted at a rapid pace by both existing on-premises Hyperion customers and new customers alike. If you were at the Sunday Symposium last year, you were among the first to see some of the latest additions before they became publicly available, and you heard from a panel of customers on their cloud journeys. Whether you have existing EPM deployments on-premises, cloud, or a little of both, this symposium is one you definitely don’t want to miss. We will cover the strategy and roadmap for all your deployment investments and continue our tradition of treating attendees to first looks at the latest innovations and works in progress. In addition, we will hear from new Oracle EPM Cloud customers.


Presented by Oracle EPM product management and development leaders, you will get unfiltered insight into our key R&D initiatives. Our goal at the EPM Sunday Symposium is to expose attendees to the latest and greatest from Oracle EPM development in these areas and offer you the opportunity to learn more in the detailed conference sessions. In keeping with our goal, the EPM Symposium's agenda reflects the late-breaking R&D efforts in the cloud which are not covered by sessions, while also relaying key efforts for on-premises EPM. We look forward to your attendance at this year's symposium.

Oracle Analytics (Business Intelligence and Essbase)

Oracle Analytics has seen tremendous innovation and growth since its introduction two years ago, and Oracle continues to enhance every aspect of the product and introduce new capabilities. In the Sunday Symposium, the Oracle Analytics Product Management team will provide deeper insight into the Oracle Analytics portfolio strategy and roadmap by exploring recent achievements in enterprise, self-service, and augmented analytics; discussing new and upcoming Essbase features; and uncovering its strategy for cloud, on-premises, and mobile.