Kscope13 Presentations

Check out the presentations listed below.



Developing Real World Applications in the Cloud
Joseph Acero , JSA2 Solutions
Co-presenter(s): Gina Haub, South Texas Project Nuclear Operating Company
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: The Basics

Cloud technologies like Amazon Web Services and the new Oracle Cloud allow for rapid application development using distributed teams. This session will walk through the set up and best practices for developing in the cloud while walking through a real world case study.

Back to Top
A Spotlight on the Smaller Improvements of APEX 4.2
Dietmar Aust , Opal-Consulting
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: No Subtopic

APEX 4.2 is once again an important major release. The marquee features are mobile applications, support for HTML5, packaged applications, and RESTful Web Services. These features are talked about a lot. But aside from that there are once again so many useful improvements to the APEX engine worth talking about. These features include read-only attributes at page and region level, shared session state across applications, debug API improvements, better JavaScript ajax functions, and improvements to interactive reports, websheets, dynamic actions, and plug-ins.

Back to Top
SQL Injection Attacks and Defenses
Tim Austwick , Recx
Co-presenter(s): Nathan Catlow, Recx
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Security is an increasingly important requirement of web applications. While performing security assessments for a diverse range of sites that used Application Express the presenter observed a common theme: SQL Injection vulnerabilities that allow attackers to access and manipulate sensitive data. Complex APEX applications have a lot of custom PL/SQL code behind the scenes that can introduce vulnerabilities into the system. The session will demonstrate the power of a SQL Injection vulnerability in the hands of an attacker. The session will then present the four forms of SQL Injection commonly seen in APEX applications, along with code examples taken from real-world systems, and discuss the ways in which the code can be restructured to mitigate the security threat.

Back to Top
Interactive Reports: With Knowledge Comes Power!
Paul Broughton , APEX Evangelists
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: No Subtopic

This presentation is designed to give both a basic and an in-depth insight into interactive reports. It will highlight the full functionality available while developing an application using interactive reports and demonstrate how interactive reports can be fully utilized by the users of an application to create customized reports and charts. The presentation will demonstrate how the APEX API can be used to create filters dynamically when the page is loaded and how to clear any filters that previously existed. It will show why interactive reports are one of the most powerful features of APEX for developers and users alike.

Back to Top
APEX Tabular Form Terrors and How to Overcome Them
Karen Cannell , TH Technology
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: The Basics

APEX Tabular Forms are handy and quite powerful right out of the box, but when your business rules take you outside of the wizards, implementing certain features be scary. Complex validations, row-based validations, cascading lists of values and other-column-dependent data selections can be terrifying. Fear no more -- this session will give you an in-depth APEX 4.1+ tabular form anatomy lesson and walk you through examples of the most common outside-the-wizard tabular form business requirements. You'll leave armed with sufficient knowledge to tackle most tabular form requirements either via APEX features or building your own custom modules with confidence.

Back to Top
Securing Oracle APEX - Cross-Site Scripting
Nathan Catlow , Recx Ltd
Co-presenter(s): Tim Austwick, Recx
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

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. The session 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. This session 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
APEX - A Training Outline
Patrick Cimolini , Skillbuilders
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Application Express - Subtopic: The Basics

Oracle Application Express (APEX) is a rapid application development framework that efficiently builds web-based applications on top of an Oracle database. The learning curve for Oracle Application Express (APEX) is relatively shallow when compared to other web-based development technologies; however, since the first APEX production release in 2003 (as HTMLDB 1.5) the learning curve has become significantly longer due to the many new features that are now available in the current version, APEX 4.2. This presentation outlines a training plan for adopting APEX. The plan lists the areas where discrete training may be required together with time and cost estimates for both self directed and classroom training. The audience, developers, and managers who are considering APEX or who are new to the technology, can use the training list as a benchmark for evaluating their APEX training needs. Training needs span the gamut from the newbie's need for ground up training to the experienced developer who is in need of a refresher or who needs to fill in some holes in their APEX knowledge. Effective APEX training enables developers and IT shops to take full advantage of the incredible productivity that is inherent in the APEX framework.

Back to Top
Intro to Responsive Design in APEX
Martin D'Souza , ClariFit
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Advanced

With the proliferation of mobile and tablet devices there's a need to build applications that scale gracefully for each device and viewing mode. APEX 4.2 introduced features to support building applications with responsive design. This presentation will be an introduction to responsive design. Items covered include: what responsive design is, how responsive design works, and how APEX 4.2 supports responsive design. This is the 1st talk in a 4 part series on responsive design in APEX.

Back to Top
Amazon Cloud Setup for APEX Environments
Martin D'Souza , ClariFit
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Moving your database into the cloud is a popular option within organizations for development all the way through to hosting production applications. There are several large cloud service providers that offer Database as a Service solutions, Amazon being one of them. This presentation will guide you through setting up an Oracle database on Amazon's Web Service (AWS) Relational Database Service (RDS) platform and setting up web servers to host APEX environments. Other areas to be discussed will be usage for secure development, offline production calculation, other AWS features, and comparisons with other cloud service providers.

Back to Top
FondsProfiler@Union Investment: The Biggest APEX Project in the World?
Niels de Bruijn , MT AG
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Advanced

For Union Investment the presenter realized a challenging APEX 4.1 project with tough requirements that made it necessary to go way beyond the standard "point & click" approach with which APEX has become famous. This presentation will demonstrate the application and give the audience an overview of some of the key features from a technical perspective.

Back to Top
You Can't Do That with APEX!
Jeff Eberhard , EberApp
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Have you been told "That can't be done with APEX!", but later find out it is actually pretty easy? Plug-ins have enabled the APEX developer a method to power boost their applications. This presentation will review various plug-ins that have made the developer's life easier. Also discover a few APEX components that you may never have known existed to help with your everyday APEX development efforts.

Back to Top
Clean Up Your APEX PL/SQL Code
Steven Feuerstein , Dell, formerly Quest Software
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: No Subtopic

Application Express generates applications built on the PL/SQL language. APEX developers write additional PL/SQL code to handle complex requirements. There is always a tendency when writing code within a UI-driven environment to treat that code rather casually; after all, it is not the main part of the application. That is a big mistake because this custom code must be maintained and enhanced. If you don't write it well, that maintenance becomes a nightmare. Have fun building those cool screens with the APEX point-and-click interface - but realize that you WILL be writing PL/SQL code and you can make a big mess of your beautiful APEX application in no time unless you take care and apply best practices to writing PL/SQL within your application.

Back to Top
Load Testing APEX Applications
Timothy Fox , Enkitec
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

This session will discuss how to load test an APEX application using open source tools.

Back to Top
Big Data and APEX
Dimitri Gielis , APEX Evangelists
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

What is Big Data about? And how does it fit with APEX? In this session, Dimitri will explain the basics of Big Data and how to integrate it with your APEX application.

Back to Top
Advanced Responsive Design in APEX
Dimitri Gielis , APEX Evangelists
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Advanced

In this presentation we will only briefly recapture why you want to use Responsive Design and how to do it. Most of our time will be spent on the problem with Responsive Design that continues when used for mobile devices: the browser still to loads all the excess weight that is not required or necessary. So the industry came up with "RESS" or "Responsive Design + Server Side components", which we will take a closer look at in combination with APEX. We will also go deeper in how to detect if the rendering device or browser is able to use certain features and what to do when they are not able to use them. This is the 4th talk in a 4 part series on responsive design in APEX.

Back to Top
Oracle Database Cloud Update
Rick Greenwald , Oracle Corporation
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: Application Express - Subtopic: No Subtopic

The Oracle Database Cloud went live in 2012. This session will give an overview of the progress of the Database Cloud, including discussions on initial rollout, subsequent enhancements, customer adoption and best practices for working with your own Database Cloud Service. In addition, the session will discuss some general direction for the Database Cloud, as well as act as a forum for your ideas for this Cloud platform

Back to Top
Automating APEX and the Underlying Oracle Database Tools for Use in Personalized Medicine Studies
Debyra Groskreutz , Hologic
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: No Subtopic

As a molecular biologist, bioinformatician, Oracle DBA, and APEX advocate, the presenter will demonstrate how using APEX functionality within the Oracle database can be used in individualized and high-throughput personalized medicine.

Back to Top
My First Mobi: Starting Mobile Development with APEX
Roel Hartman , APEX Evangelists
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics

Learn how to build a native looking web application for mobile devices, from start to finish!

Back to Top
Automatic for the People: End to End Automatic Testing of Your APEX Application
Roel Hartman , APEX Evangelists
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: The Basics

Learn how to use automated front-end/user interface testing in an APEX environment, making your project (even) more professional with a reliable outcome.

Back to Top
Integration APEX and E-Business Suite: Distributed Account Management Automation Case Study
Raj Lalchandani , Stanford University
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Advanced

Stanford University creates thousands of accounts annually to effectively manage financials for schools and departments, research grants, capital projects, and major gifts. Request for these accounts were initiated on paper forms by distributed financial staff and approvers and manually entered by centralized financial departments into Oracle Financials. In 2012, a custom Application Express application was built and integrated with Oracle Financials to automate this complex and data- intensive manual process. This session, presented by the project manager and development manager, will cover the project perspective, application architecture & design, development challenges, and project benefits.

Back to Top
Building a Responsive Application using Twitter Bootstrap
Mark Lancaster , Thiess
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: No Subtopic

APEX 4.2 introduced declarative "grid-layout" functionality to simplify responsive web design - an approach which dynamically scales and adjusts page layouts to suit the browsing device. So how do you integrate a popular responsive design framework like Twitter Bootstrap into APEX 4.2? What are the issues? How well does it work? This presentation discusses responsive design, the integration process, and design considerations to help build an application that dynamically adjusts screen layout to work on desktops, tablets and smart-phones. This is the 3rd talk in a 4 part series on responsive design in APEX.

Back to Top
Explore New Data Dimensions with APEX and Free/Open Source Graphing Libraries
David Mann , DBI Consulting
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: No Subtopic

Explore the wealth of custom graphing options available with three free/open source JavaScript libraries that can be integrated into Application Express and other web frameworks. The demo will include using APEX and D3.js to create two useful types of graphs that cannot be created with basic APEX graphing library: a connected node graph and an animated line graph that is dynamically updated with data from an Oracle DB in real time.

Back to Top
Case Study: Managing User Accounts in Google and LDAP from APEX
Raj Mattamal , Niantic Systems
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Identity Management can be a complex business even in the simplest cases. When business rules get complicated though, things can get unwieldy quite quickly. This session shows how APEX was a great fit to manage a more complex scenario managing thousands of student accounts migrating to Google Mail while using LDAP for authentication. Now university administrators can manage all the user accounts, students can self-service them seamlessly from within APEX applications. Hear some of the hurdles overcome and lessons learned during this large implementation, and in cases such as Google Calendar, hear the directions in which this APEX-based identity management solution is heading.

Back to Top
Dynamic Action Deep Dive 1
Dan McGhan , Enkitec
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: No Subtopic

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Back to Top
Dynamic Action Deep Dive 2
Dan McGhan , Enkitec
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: No Subtopic

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Back to Top
Dynamic Action Deep Dive 3
Dan McGhan , Enkitec
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: Application Express - Subtopic: No Subtopic

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Back to Top
APEX Technical FAQ
Francis Mignault , Insum Solutions
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Common questions on APEX often are about the infrastructure and on how complex it is to install, maintain, and upgrade. This session will demystify the APEX installation. Architectures, install, upgrade, tablespace management, schema management, installing APEX with EBS, and backups will be some of the subjects covered in this session.

Back to Top
APEX and Authentication Plug-ins: An Example
Tony Miller , LuvMuffin Software
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

With APEX 4.x, we as APEX developers were given a GREAT gift in plug-ins. Then in APEX 4.1 we were given the ability to build an authentication plug-in to replace the old style function-driven coding for authentication schemes. This presentation will walk through taking an existing authentication scheme (custom, table driven) and show how to build a plug-in that can be dropped into your application(s) to allow custom table-driven authentication.

Back to Top
Techniques for Achieving Section 508 Compliance of APEX Applications
Brad Nance , Oak Ridge National Laboratory
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: No Subtopic

"508" refers to Section 508 of the Rehabilitation Act of 1973 that was later expanded by the Workforce Investment Act of 1998. The act requires that when Federal agencies develop, procure, maintain, or use electronic and information technology, they must ensure that it is accessible to people with disabilities. This presentation will present some of the challenges of developing 508 compliant APEX applications and will demonstrate techniques that can be used to overcome those challenges.

Back to Top
Shootout: Oracle DB Cloud vs. Amazon RDS
Jan Navratil , CampusIT
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

There are too many clouds! What's better? What's more secure? How much do I have to pay? Rather than listing all of them, this presentation will discuss two major players and literally slice and dice both offerings from the architecture, availability, security, manageability, and cost perspective - as we learned when serving universities from the cloud. It will highlight relevant benefits and limitations when moving your APEX solution to the cloud. This session will help you make the right choice!

Back to Top
Mobile Plug-in Development
Matt Nolan , APEX Freelancer
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Now that 4.2 has landed with built-in mobile support, how do we extend the capabilities with custom components like autocompletes, maps, charts, photo capture, etc.? You guessed it, by creating plug-ins. In this presentation I'll walk through the basics ingredients for developing plugins using jQuery Mobile, Sencha Touch, optionally with Apache Cordova(Phonegap). We'll then explore a number of demos from simple to advanced plugins and peek into their design. With one feature demo that is guaranteed to impress! Plugins provide the ability for you to take your development productivity through the clouds.

Back to Top
Hands-on Training: Bring Your Tablets! (Because You're Gonna Build a Mobile Apex App in One Hour!)
Chris Ostrowski , Avout
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Application Express - Subtopic: Hands-on Training

End-users are increasingly demanding mobile access to corporate applications. New languages, development tools, skill sets, and determining platforms to support can make the entry into mobile application development difficult for organizations. A new technology makes decisions about mobile development much easier: JQuery Mobile. Oracle APEX integrates easily with JQuery Mobile. This combination can be used to create mobile applications that are supported on a wide range of mobile devices relatively simple. This presentation will walk attendees through the steps of building a mobile application using Oracle Application Express. Attendees are encouraged to bring an iPad (or other mobile device) to actively participate and see the final results of their work.

Back to Top
Oracle APEX Invalidates the Project Management's "Triple Constraint"
Bharat Pappu , DC Courts
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics

Triple Constraint, per wiki: "You are given the options of Fast, Good, and Cheap, and told to pick any two. Fast refers to the time required to deliver the product, Good is the quality of the final product, and Cheap refers to the total cost of designing and building the product. This triangle reflects the fact that the three properties of a project are inter-related, and it is not possible to optimize all three -- one will always suffer. In other words you have three options: * Design something quickly and to a high standard, but then it will not be cheap * Design something quickly and cheaply, but it will not be of high quality * Design something cheaply and with high quality, but it will take a long time All of the above statements have been proved otherwise; the District of Columbia Courts have designed and developed around fifteen division/departmental applications with a custom theme in under six months!

Back to Top
Oracle Application Express 5.0
David Peake , Oracle Corporation
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: No Subtopic

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 will also provide an insight into the major new capabilities being built into Application Express 5.0.

Back to Top
Hands-on Training: Oracle Application Express 1
David Peake , Oracle Corporation
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Hands-on Training

Rather than forcing you to choose just one lab session to attend, the Oracle Application Express Development Team is conducting an al la carte hands-on-lab session in which you get to choose the labs you're interested in. You have over two hours of sessions from which to choose a wide variety of different labs on Application Express.

Back to Top
Hands-on Training: Oracle Application Express 2
David Peake , Oracle Corporation
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Hands-on Training

Rather than forcing you to choose just one lab session to attend, the Oracle Application Express Development Team is conducting an al la carte hands-on-lab session in which you get to choose the labs you're interested in. You have over two hours of sessions from which to choose a wide variety of different labs on Application Express.

Back to Top
Pimped APEX Development
Peter Raganitsch , click-click IT Solutions
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

You already know how to build beautiful APEX applications, but do you still struggle with the pre-historic APEX Application Builder? This session shows how you can make the Application Builder do what you want and how you can easily extend it.

Back to Top
APEX at Your Fingertips - Full Keyboard Control
Peter Raganitsch , click-click IT Solutions
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Having beautifully designed and well-structured applications is one of the things easy to achieve in Oracle APEX. It gets more complicated when a user requests to run your application keyboard based only, without using a mouse or any other pointing device. How can you navigate through your application? What about Tabular Forms? Learn a quick and easy way to achieve full keyboard control in your APEX application.

Back to Top
Websheet Applications - User Access Overview
Karen Reliford , TransAmerica Training Management
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Websheet Applications bring an interesting dynamic to Application Express in that they allow users to control not only content of what's in the application, but also to control to some degree just who gets access to the application. Come to this session to gain a better understanding of user access control in Websheet Applications.

Back to Top
That's Not Where I Want That!
Jorge Rimblas , Enkitec
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Application Express - Subtopic: The Basics

You're creating APEX applications already, but you wish your screens would look better. Moving regions around, changing their size, width, placing items, and buttons; it's all frustrating and painful. In this session you'll learn how to position your elements and better implement the vision you have for your applications. The session will go into details of the attributes provided by APEX to make this happen. Learn some HTML and CSS that will allow you to personalize your applications.

Back to Top
Building a Responsive Application Using Theme 25
Christian Rokitta , themes4apex.com
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Advanced

Responsive Web design is the approach that suggests that design and development should respond to the user's behavior and environment based on screen size, platform and orientation. The practice consists of a mix of flexible grids and layouts, images and an intelligent use of CSS media queries. What are CSS grids and media queries? How do they work and how can I integrate them in my APEX application design? These are the questions I will answer during my presentation as I build an example explication using Theme 25, the responsive theme provided in Oracle Application Express 4.2. This is the 2nd talk in a 4 part series on responsive design in APEX.

Back to Top
Confessions of an APEX Design Geek
Christian Rokitta , themes4apex.com
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics

Oracle Application Express has a very flexible theming mechanism, allowing you to completely customize your applications interface. Unfortunately, you will only find little documentation on this subject. This presentation will introduce you to the basic concepts of APEX templates and themes and suggest a few different approaches to modifying existing themes or creating a new custom user interface in APEX.

Back to Top
Making Sense of Application Express Security
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics

With the many options in Application Express authentication and authorization, it can be difficult to determine which method is right for you. This presentation will investigate these various methods and see how they work. The presentation will also take a look at session state protection to help you prevent URL tampering.

Back to Top
APEX: When Push Comes to Shove (or Using HTML5 WebSockets)
John Scott , APEX Evangelists
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: The Basics

This session will cover one of the nice new features in HTML5, namely WebSockets. Rather than using the traditional polling methods to determine when data has changed in your application, WebSockets allow the server to PUSH notifications to the browser, which has all kinds of implications for scalability and usability of applications. The presenter will show some different ways in which you can use WebSockets in any APEX application to really make your application stand out.

Back to Top
APEX: Version Control with Git
John Scott , APEX Evangelists
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: Advanced

Internally at APEX Evangelists, they used to use Subversion for their source-control, but now they use Git. Why? Well attend this session to find out why they made the switch! This session will cover what Git is and how you can leverage it to provide a multi-developer environment effectively.

Back to Top
Mobile Development with Oracle Application Express 5.0
Marc Sewtz , Oracle Corporation
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Application Express - Subtopic: No Subtopic

Mobile and tablet devices have become an important part of today's business. With over 70% of organizations already using or planning to use custom mobile apps, companies can no longer afford to stand on the sidelines and need to adopt a mobile strategy now. Oracle Application Express provides customers with powerful tools to quickly and efficiently build mobile web apps and extend their existing Desktop apps for mobile use. Oracle Application Express 5.0 further expands the existing mobile development features by adopting the latest release of jQuery Mobile and introducing a user interface specifically designed for tablet use. This session provides an overview of the new mobile capabilities and includes a live demonstration of how to quickly build cross-platform, responsive apps for smartphones and tablets

Back to Top
APEX Behind the Scenes
Scott Spendolini , Enkitec
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Oracle Application Express is truly an amazing and robust development platform, enabling developers to build applications to meet almost any requirement. But behind the scenes, this sophisticated development tool is quite simple. This session will explore the inner-working of APEX and describe just what happens when you view or submit a page. The overall intention of discussing APEX at such a low level is to provide APEX developers - beginners & advanced alike - with a better understanding of the environment, which will enable them to build better applications.

Back to Top
Building Commercial Applications with APEX
Scott Spendolini , Enkitec
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Application Express - Subtopic: The Basics

Oracle Application Express has proven itself as a powerful development platform for internal development needs in countless organizations worldwide. One of the new frontiers it is starting to conquer is building commercial applications. This session covers what it takes to use Oracle Application Express as a platform for building commercial applications. It looks at all facets of the software development lifecycle and discusses different infrastructures, deployments, processes, and tools used to make development with Oracle Application Express as streamlined and cost-effective as possible. Real-world examples are given throughout the session. Much of what is discussed in this session can also be applied to medium to large Oracle Application Express projects.

Back to Top
Using the APEX_WEB_SERVICE API
Brian Spendolini , Oracle Corporation
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Service Oriented Infrastructures are becoming the norm in the enterprise. Our APEX apps need to fit into this architecture by being able to call and consume web services. See how to use the APEX_WEB_SERVICE API to extend your applications to fit into an SOA environment.

Back to Top
Compelling, Dynamic, Graphical -- And If We Are Lucky -- USEFUL E-Mail Generation
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Advanced

With all of the draws to get individual attention from users, how do you make e-mail communication effective? How many systems are built where the primary use is to generate SPAM mail? This presentation will show techniques for including complex reports, dynamic graphics, and charts within emails without writing code by hand. The session will also review the database technology required to enable the techniques shown and considerations for how it can be accomplished. Examples will include: Consuming APEX Page output to use as an HTML email source Creating dynamic graphs that are sourced from APEX Dynamic graphic content Effective email follow-up methods like approvals

Back to Top
LOBS, BLOBS, CLOBS -- Dealing with Attachments in APEX
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: The Basics

APEX has the ability to leverage the database to store and manage files submitted by the user. This is valuable when building applications allowing the developer to create rich collaboration environments. This presentation will show how attachments work in APEX and show examples of how they can be used both in the user interface code as well as in code. The session will also be showing some of the considerations when creating tables that contain LOB content. Individuals will be given both a review of the APEX wizards and expand it with techniques for using the LOBS and information necessary to manage the database objects.

Back to Top
Deploying and Developing Application Express with Oracle Database 12c
Jason Straub , Oracle Corporation
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: No Subtopic

Learn how you can take full advantage of this new pluggable architecture with various deployment options for Application Express. This session will also cover new capabilities defined within Application Express to take advantage of other Oracle Database features.

Back to Top
EUAD, BUAD, and APEX: End-User Produces High-Quality Software with APEX
Ricardo Stumpf , Brazilian Court of Audit
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

End-User and Business Unit Application Development are new paradigms in which end users produce their own software, freeing corporate IT developers to work on other business priorities. Is APEX a good fit for EUAD and BUAD? Can end users assisted by inexperienced IT interns develop high-quality software using APEX? This session will show you that the answer is yes to both questions. Based on a five-year program now involving 100 APEX developers, you'll learn how to make it happen based on four principles that guide all the technical and governance processes.

Back to Top
Software Evolution: Integrating Good Old Forms Into Your APEX Applications
Peter Vaal , Transfer Solutions
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: Advanced

This presentation will show how the power of Forms applications can be combined with the ease of use and smooth user interface of Application Express. The evolution of applications to new technology without loosing past investments is one reason to integrate Forms and APEX, picking the best of both breeds is another.

Back to Top
New Region and Item Types in Application Express 5.0
Patrick Wolf , Oracle Corporation
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: No Subtopic

Application Express 5.0 introduces new region and item types. Learn about how these new capabilities will make it easier and more productive to build APEX applications in Application Express 5.0.

Back to Top
Find us on Facebook
Follow Us