Favorites Only?



    TrackSub catTypeTitleRoomPresenterDescription
    Application ExpressAPEX Real WorldSolutionsThis Is How We Do ItIris/Lily Niels de Bruijn (MT AG)APEX is not equal APEX. Each project is different, but after 12 years doing APEX projects, we see certain patterns:

    - in the way we work together in the team
    - in the way we implement the application (automated/manual processes, using plugins, using a page generator for maintaining master data)
    - in the way we interact with the end user (meetings, preview version)
    - in the way we automate things (CI/CD, Jenkins, Subversion)

    The objective in this presentation will be to present three types of typical APEX projects that handle these aspects differently.
    Application ExpressOther Application ExpressTips and TechniquesIntroduction to APEXLarkspurPatrick Wolf (Oracle Corporation)Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is aimed squarely at those who’ve only ever heard of Application Express or are just starting out.
    DatabaseDB DevBest PracticesThick Database is Alive: Leveraging the Oracle Database SQL and PL/SQL to Simplify Any User Interface Application DevelopmentBluebonnet/DogwoodPeter Koletzke (Quovera)Whether you develop applications for an Oracle database in APEX, ADF, MAF, JET, MAX, ABCS, Forms, or any other development framework or programming language, the development approach known as "thick database" can provide many benefits in productivity, code reusability, and ease of application maintenance. This approach has been discussed by Oracle users for over a decade, with early evolution due to discussion in ODTUG channels, but the topic is rarely mentioned these days.

    The thick database approach consists of centralizing as much application logic as possible in database code, which greatly simplifies the work needed in the user interface application. It shields the application somewhat from UI technology changes, so if an application framework needs to be changed, the amount of code to rewrite is much less than if the application was the main source of business logic. In addition, this technique allows for a better use of development talent: SQL and PL/SQL experts can focus solely on the database portion of the application, whereas UI specialists can address just the user interface portion of the application.

    This presentation explains the benefits, principles of, and guidelines for using this approach. It discusses how business rules logic can be centralized and standardized so that application updates due to business changes are much easier. It also describes different levels at which you can use the thick database principles: extreme, modified, and conservative, and how to decide which level to use. It explains how you would decide which business rules should be implemented in the user interface even if they are also written in the database.

    Since thick database is aimed at implementing business rules logic, the session suggests a simple system you can create to track business rules, and how it can form the basis for the thick database code you write as well as serve as a starting point for creating test plans. The session then shows examples of the main SQL and PL/SQL code components you might use to implement thick database principles: table APIs, complex views with INSTEAD OF triggers, and business rules procedures.
    ConferenceBreaksBreakBreakExhibit HallODTUG (ODTUG)-
    ConferenceEventsWelcome ReceptionWelcome ReceptionExhibit HallODTUG (ODTUG)-
    ConferenceEventsHappy HourHappy HourExhibit HallODTUG (ODTUG)-
    Application ExpressAPEX Detail PlungeBest PracticesAPEX and the Thick Database ParadigmCibolo Canyon 5Anton Nielsen (C2 Consulting, Inc.)
    Richard Soule (C2 Consulting, Inc.)
    In July 2016, Bryn Llewellyn published "Why use PL/SQL?," an Oracle white paper expounding upon the virtues of the thick database approach--focusing on the benefits of data integrity. Toon Koppelaars has a similar presentation that focuses on the performance gains of the thick database. Both presentations provide specific recommendations targeted to the Java and mid-tier centric development communities. Most of these recommendations apply to APEX applications as well. This presentation will provide specific guidance on applying them in APEX.

    This presentation will discuss the benefits of the thick database paradigm: data integrity, performance, and security. I will discuss schema isolation, the use of business focused pl/sql APIs, providing specific methods to implement these within an APEX development environment. I will also cover APEX specific deviations from Bryn's white paper and real-world considerations on how to determine when full implementation of the thick database paradigm may not apply.
    Application ExpressAPEX Real WorldTips and TechniquesDocker for DummiesIris/Lily Roel Hartman (APEX Consulting)In this presentation we will walk through the following subjects:
    - What is Docker
    - Where do I get my images
    - Pull an image
    - Start a Docker container / Stop / Restart
    - Use a Docker container for APEX Development : Via the browser, SQL Developer, SQL Plus, etc
    - Make host directories accessible within the container
    - Use scripts to modify the image or create your own one
    Application ExpressAPEX Real WorldTips and TechniquesHigh Performance APEX (or Don't Keep the Users Waiting)Iris/Lily John Scott (APEX Evangelists)We have an application that supports over 3000 daily users, I have learned a lot about how to diagnose where performance bottlenecks are and how to fix them.

    In this session, I'll cover the following topics -

    1) Web server caching and performance
    2) Profiling your APEX application
    3) Common performance issues and resolutions
    Application ExpressAPEX Real WorldSolutionsUncover the TruthAzaleaOliver Lemm (MT AG)Often a developer gets an old application without documentation or even without having a developer who worked on it before. In this situation you need an information how the application is structured and where is the customized code. Based on the APEX Metadata Repository all the custom CSS, JavaScript and PL/SQL code is identified. By knowing the amount of code you get an overview of the complexity of your pages. Another interesting fact is the navigation inside your application. By identifying all links, branches and redirects you can visualize the navigation path of your application which helps even more to understand how it works.
    All this information is shown in an APEX Application itself and uses Reports and Charts to visualize it and make it possible to drill down into the application you have to extend or migrated.
    ConferenceEventsSpecial EventSpecial EventBuses Depart JW Marriott for Special EventODTUG (ODTUG)The Southern Pacific Depot (Sunset Station)
    ConferenceMealsBreakfastBreakfastTBDODTUG (ODTUG)-
    ConferenceMealsBreakfastBreakfastTBDODTUG (ODTUG)-
    ConferenceMealsBreakfastBreakfastExhibit HallODTUG (ODTUG)-
    ConferenceMealsBreakfastBreakfastExhibit HallODTUG (ODTUG)-
    ConferenceMealsBreakfastBreakfastTBDODTUG (ODTUG)-
    ConferenceMealsLunchLunchCibolo Canyon 6/7ODTUG (ODTUG)-
    ConferenceMealsLunchLunchCibolo Canyon 6/7ODTUG (ODTUG)-
    ConferenceMealsLunchLunch and LearnCibolo Canyon 6/7ODTUG (ODTUG)-
    ConferenceMealsLunchLunchCibolo Canyon 6/7ODTUG (ODTUG)-
    ConferenceBreaksBreakBreakTBDODTUG (ODTUG)-
    ConferenceBreaksBreakBreakTBDODTUG (ODTUG)-
    ConferenceBreaksBreakBreakExhibit HallODTUG (ODTUG)-
    ConferenceBreaksBreakBreakExhibit HallODTUG (ODTUG)-
    ConferenceBreaksBreakBreakExhibit HallODTUG (ODTUG)-
    ConferenceBreaksBreakBreakExhibit HallODTUG (ODTUG)-
    ConferenceBreaksBreakBreakTBDODTUG (ODTUG)-
    ConferenceBreaksBreakBreakTBDODTUG (ODTUG)-
    ConferenceEventsHappy HourHappy HourExhibit HallODTUG (ODTUG)-
    ConferenceEventsMonday Night Community EventsMonday Night Community EventsTBDODTUG (ODTUG)-
    ConferenceEventsClosing SessionClosing SessionTBDODTUG (ODTUG)-
    Application ExpressOther Application ExpressSunday SymposiumsAPEX Sunday Symposium: APEX 5.1 Advanced Universal ThemeGrand Oaks G/E/F Shakeeb Rahman (Oracle Corporation)summary to come
    Application ExpressOther Application ExpressSunday SymposiumsAPEX Sunday Symposium: APEX 5.1 Other Advanced New FeaturesGrand Oaks G/E/F Patrick Wolf (Oracle Corporation)APEX 5.1 Other Advanced New Features
    Application ExpressOther Application ExpressSunday SymposiumsAPEX Sunday Symposium: Update from DevelopmentGrand Oaks G/E/F Joel Kallman (Oracle Corporation)summary to come
    Application ExpressAPEX IntegrationTips and TechniquesLet APEX Access Your ComputerIris/Lily Peter Raganitsch (FOEX GmbH)This is a session about what Electron is and how to use it in combination with Oracle APEX in the most secure way as possible.

    That means we'll talk about Electron, Node, IPC, and JS in APEX.

    There will be a bunch of examples and finally the pre-built-browser of the OpenSource apex-client-extension project.

    I'll try to explain everything, but keep it on a light level, so that everyone should be able to follow.
    Application ExpressOther Application ExpressTips and TechniquesMigrating Oracle Forms to the Cloud Using Application ExpressLarkspurDavid Peake (Oracle Corporation)Oracle Forms is still being developed and for those whose requirements are being fully met, and are up on a supported release, there is no reason to move off Forms. However, if you are on an older release of Oracle Forms, or need to deliver modern, intuitive, self-service or mobile applications then Application Express is an excellent option.

    Learn what is involved in building out using Application Express, the do’s and don’ts, how to use the APEX Migration Project, and more.
    Application ExpressAPEX Real WorldHands-On TrainingHands-On Lab: Transitioning to Oracle Application Express 5 Universal ThemeGoldenrodShakeeb Rahman (Oracle Corporation)Oracle Application Express 5 introduces many new features that enable you to quickly build modern and beautiful HTML5 applications. The new Universal Theme implements current design trends and utilizing the new declarative template options, and puts powerful CSS3 techniques at your fingertips. In this session, you will walk through transitioning your existing application to the new Universal Theme. Using some of the packaged apps included with Oracle Application Express 4.2 as examples, we’ll demonstrate step-by-step how to transition these apps to Oracle Application Express 5.
    Application ExpressAPEX Real WorldBest PracticesFrom APEX App to Apple App Store – Simple Steps for Successful SubmissionLarkspurStephen Lloyd Smith (CampaignShortCuts)
    Roel Hartman (APEX Consulting)
    Successfully submitting an Oracle Application Express based application for acceptance in the Apple App Store requires navigating numerous technical, graphical, and process challenges. This session will provide APEX developers with the necessary road map to easily navigate those challenges to achieve Apple App Store acceptance on their first submission based on a recent acceptance case study. The steps presented in the road map are applicable whether the application is business to business or consumer focused. The session will begin with a recommended best practice task list to meet Apple's stringent graphic and process requirements while balancing the needed APEX mobile specific coding. In-depth discussion will cover the coding technique to achieve the required offline notification when an APEX app is disconnected from the network, as well as, the technique to automatically re-start the application when network connectivity is restored. Technical topics will also include the method for the APEX application to access JavaScript or other files embedded in the local iOS application, needed technique to allow hybrid iOS and web functionality using a code example with hyperlinks, and template and graphical updates to support multiple iOS devices and meet Apple's iOS Human Interface Guidelines. Process topics will include best practices on meeting Apple mandatory steps from Security Certificates, through Privacy Policy and iTunes Connect publication requirements. This best practice session will provide APEX developers with the road map and techniques needed to successful publish their apps to the Apple App Store.
    Application ExpressAPEX IntegrationTips and TechniquesDeliver a Knockout with Your APEX ApplicationsIris/Lily Jorge Rimblas (Insum Solutions)OracleJET presents some impressive interactive functionality, but none of it would be possible without KnockoutJS. Understanding KnockoutJS will be a critical skill in the evolutionary path of JavaScript in our APEX application. Instead of making OracleJET the star, I plan on focusing on how KnockoutJS works and how to integrate it with our APEX pages. The sooner we get acquainted with this technology, the better we'll be able to use it.
    Application ExpressAPEX Real WorldSolutionsGetting Your Grips on Excel ChaosLarkspurNiels de Bruijn (MT AG)We have done a lot of projects where inefficient business processes done with Excel and email where replaced by APEX.

    What is typically seen in such an Excelsheet? Which Excelsheets are worthwhile migrating to APEX? How do you handle Excel-specific functionality (cursor navigation, fixed columns, VBA-Code, macros, transactional behavior, etc.)
    Application ExpressAPEX Detail PlungeTips and TechniquesFinally Understand How APEX WorksCibolo Canyon 5Peter Raganitsch (FOEX GmbH)Creating APEX Applications is too easy. Sometimes developers forget to learn about the basics, because APEX already lets them do advanced stuff. Until they encounter an error and don't know what to do.

    In this session I'll try to explain what APEX is and how it works.
    Application ExpressAPEX Real WorldTips and TechniquesCapturing and Manipulating Images with APEX and More!LarkspurAdrian Png (Insum Solutions)It is common these days to have business requirements that involve the capture, storage and manipulation of multimedia files. This session will provide attendees with introduction to various methods and approaches to implement these features in their APEX application. The speaker will also be presenting real world examples on how some of these techniques were applied.

    The session will open with an introduction to media capture using a web browser. The presenter will introduce the related W3C specifications that determine how web browsers interact with devices to capture and display media. Demonstrations on the capture process will allow attendees to appreciate these concepts.

    Image manipulation can be performed either on the client-side or server-side. The session will first explore the use of Oracle Multimedia and considerations when choosing this approach including features, functionalities and performance issues.

    Performing the task on the client-side opens up more possibilities. The presentation will then examine what available JavaScript libraries are available to manipulate images. The presenter will also provide a basic introduction to the Canvas API and how it is used as the underlying technology behind many of these libraries.

    The following will be demonstrated:
    - Capturing media from a device (webcam)
    - Oracle Multimedia for extracting metadata and image transformation like cropping and resizing
    - Adding image overlays on an image using accompanying data, e.g. geocoordinates
    - Drawing on a canvas and persisting the image in a database, e.g. capturing user signatures

    The presentation will end by discussing other interesting JavaScript libraries that support computer vision, allowing developers to implement advanced functionalities like facial recognition and feature detection.
    Application ExpressAPEX Detail PlungeTips and TechniquesjQuery Widgets in APEXIris/Lily Tom Petrus (iAdvise)APEX comes bundled with jQuery, a JavaScript framework, and by extension it comes with jQueryUI. jQueryUI provides several widgets which implement much-used features, such as datepickers or modal dialogs. Look no further than the interactive report "Actions": "Select columns", "Filter", "Sort" are all displayed in a jQueryUI Dialog. APEX's datepicker, similarly, is nothing short of a jQueryUI Datepicker. This is great, as it opens up options for us developers: while plenty of options are usually exposed in the APEX builder, they're usually not all that are available.
    But those are just the "external" widgets. Since APEX 5, the team has been creating jQuery widgets themselves. The tree component, the menu widget and interactive reports are the prime examples of these. It's obvious a lot of time has been put into these widgets and more will likely be introduced as time goes on.
    But how can you manipulate these widgets? Maybe there are options you can't set through the builder. Maybe there are even options you're not aware of! With native jQuery widgets these features aren't hard to determine, and as such they can form an entry into how to work with their options. For APEX widgets there is even no real documentation available. One of the hardest blows for many as they moved from APEX 4.2 to 5.0 was how the complete interface of interactive reports was gone. Maybe you still remember the "gReport" variable and how you could read or manipulate IR workings through it, and how this doesn't work anymore in APEX 5. But you haven't lost all control or influence over the workings of IR javascript. There are still ways to customize: extending jQuery widgets!
    We'll have a look at the general structure of widgets, at some of the widgets APEX uses and implements, how they can be customized or even extended.
    Application ExpressAPEX IntegrationBest PracticesProfessional JavaScript Error: Logging for Oracle APEXLarkspurKai Donato (MT AG)I will show how to implement exception-handling into your JavaScript-Code to avoid crashing the JavaScript Runtime and use the remaining time after the error to report it into the database.
    Further there will be multiple approaches how you can enrich your JavaScript for getting the most out of the debugging process and where to place additional code to calculate additional metrics. Using the collected data we can analyze the performance through out the application and create reports and charts on top of that.
    Application ExpressOther Application ExpressTips and TechniquesExplore the APEX APIsCibolo Canyon 5Martin D'Souza (Insum Solutions )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.
    Application ExpressAPEX Real WorldHands-On TrainingHands-On Lab: Building a Basic Demo Application Using Oracle Application ExpressGoldenrodJason Straub (Oracle Corporation)
    David Peake (Oracle Corporation)
    This one “double” session (two-plus hours) is designed to take you through building a comprehensive application using Application Express. It is designed for people with no prior knowledge or very little experience developing with Application Express. You will learn how to develop a large number of different application components and walk out with the confidence and understanding of how to start building your own applications using Oracle Application Express.
    Application ExpressAPEX Real WorldSolutionsGET POST ORDS JSON: Web Services for APEX DecodedLarkspurScott Spendolini (Sumner Technologies)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.
    Application ExpressAPEX IntegrationBest PracticesJavaScript and CSS for PL/SQL DevelopersCibolo Canyon 5Jorge Rimblas (Insum Solutions)Working with HTML, JavaScript, and CSS doesn't have to be hard. However, as a SQL and PL/SQL developer, it can be daunting to venture into new technologies. By explaining some basics, providing some analogies, and clear examples I expect to get attendees more comfortable with web technologies.
    Application ExpressAPEX IntegrationTips and TechniquesOMG! JavaScript Straight from the Oracle DatabaseIris/Lily Dimitri Gielis (APEX R&D)-Explain the issue I had where native APEX and database functionalities were not enough -> JavaScript to the resque
    -Explain Nashorn (JVM which allows to run JavaScript, Node.JS from the database...)
    -Give examples and use cases where it benefits running Javascript straight from the database
    -I plan to do a lot of Live demos so people can see how APEX apps can benefit from Javascript in the database
    Application ExpressAPEX Real WorldCase StudiesLife After Forms: The Move to APEXLarkspurAlex Nuijten (allAPEX)During a project where an application needed to be migrated to APEX we had to make several choices on how to tackle the problems that arose.... If only the Forms application was built using the Thick Database Paradigm, it would have saved us a lot of trouble... We are not going to make this mistake again and harden the database application before the APEX Forms and Reports are built. Get the business users involved as quickly as possible.
    • 1 - 50

    Book an APEX Expert

    Meet one-on-one with on of Insum's Oracle ACEs and Experts, and let them help your business and optimize your APEX development processes.
    • Meet our experts at the Insum booth
    • Each consultation will be 30 minutes
    • Limited meetings will be assigned on first-come, first-serve basis