Wednesday Apr 15, 2015

Oracle APEX 5 Is Here

Oracle Application Express 5 is now available.   <DOWNLOAD HERE>

Congratulations to Joel Kallman's team, who hosted a great Google Hang out this morning to share the big news. 

The #orclapex team discussed new capabilities, improvements and what to expect next.  

And now --> Quick Links:  

Oracle Application Express Community Forum   and   Oracle Application Express Product Information

So, What do you need to know about Oracle APEX 5?

Here's what modern database web application development looks like: 

Application Express 5 Early Adopter 3 Home

Page Designer: The World's Most Advanced Browser-based IDE

Page Designer is a completely new IDE designed to greatly improve developer's productivity, allowing you to very quickly enhance and maintain pages within Application Express.

Application Express 5 Page Designer

Cohesive User Experience

With Page Designer, there is no context-switching when modifying multiple components. It is no longer necessary to drill into component pages simply to make changes. All modifications occur within Page Designer, where you can undo and redo changes as necessary, before saving your page.

Better Visual Representation

You can gain an immediate understanding of how your regions and items are laid out within the Grid Layout. Changes to components on your page are immediately reflected across the Tree and Grid Layout Page Designer. Additionally, errors and warnings are immediately visible.

Intuitive Drag and Drop

Page Designer completely reimagines 'drag and drop' and provides an entirely new way to develop pages on the fly. In the Grid Layout pane, you can drag new components from the Component Gallery, or move and copy existing components around. In the Tree pane, you can drag to move and copy multiple components at a time.

Enhanced Code Editor

It's never been easier to write code in Application Express. The new code editor provides SQL and PL/SQL validation with inline errors, auto completion, syntax highlighting, search and replace with regex support, complete with undo and redo support. You can even specify your preferences for tabs, indentation, and color scheme. 

Universal Theme: a better UI for your apps

Universal Theme is an all-new user interface for your applications that has been built from the ground up for Application Express 5. It is a simpler, yet more capable theme that does away with excessive templates and enable effortless customization with Theme Roller, Template Options, and Theme Styles. Universal Theme is the culmination of all of our UI enhancements and aims to empower developers to build modern, responsive, sophisticated applications without requiring expert knowledge of HTML, CSS, or JavaScript. 

Application Express 5 Universal Theme

Theme Roller

This flagship feature of Universal Theme enables easy customization of the look and feel of an application. You can tweak a number of style attributes and see changes applied to your application in real time. Once you are satisfied with the result, you can save your changes as a Theme Style directly to your app.

Template Options

Easily customize the way buttons, regions, lists, and other template-based components appear. A single template can be displayed in several different ways using these options. Universal Theme enables developers to use fewer templates but build far more versatile applications.

Absolutely Responsive

Universal Theme has been designed to be responsive from the very beginning. You can build fully responsive apps that work flawlessly across a variety of screen sizes and form factors. Universal Theme includes key enhancements such as enabling complex form layout and using flexible grids.


Universal Theme delivers most accessible user interface for applications built with Application Express. Theme Roller can be used to build accessible Theme Styles and includes built-in WCAG 2.0 color-contrast checking. 

Additional Features in Application Express 5

Release 5 includes many additional features, enhancements, and more! Here are some highlights:

All New Design

We designed a completely new user interface for Application Express that is focused on improving user experience through simplicity and removing clutter. The new design uses a beautiful new color palette, carefully crafted icons, vastly improved menus and navigation, better accessibility and keyboard support, more intuitive page layouts and much more...

User Interface Enhancements

With the development of Universal Theme, we also added several enhancements to how Themes and Templates are handled. This release has features such as Theme Subscriptions, Template Options, Theme Styles, and much finer control over templates and the HTML emitted by the APEX engine. It is now easier than ever to fully control the UI of your application.

Multiple Interactive Reports

The most requested feature for Application Express is here. Easily create multiple interactive reports on a single page, and gain insights into your data like never before. We've also completely revamped the user interface to provide a consistent experience, and made end user customization even easier with modal dialogs.

Modal Dialogs

Now you can easily define modal (and non-modal) pages complete with the ability to utilize standard page processes. No longer will you need to hack a page using JavaScript and performing a lot of hand-crafting. Instead just set the display type and appropriate template and let Application Express take care of the rest.

Better Navigation

Static or dynamic lists can be used as the basis for your application's navigation menu and navigation bar. Navigation Menus can be positioned to the top or side of your pages, and can be rendered based on any List template, enabling nested navigation items, keyboard support, and greater accessibility.

More Interactive Report Enhancements

Interactive Reports feature an all-new user interface for displaying your data, report settings, support for fixed column headers, and is more accessible than ever before. Additionally, end users can now define a pivot report at runtime, which is similar to defining a group report.

All New Calendar

The new calendar component comes with built in support for Month, Week, Day, and Agenda views and is much easier to customize. The calendar is based on the popular FullCalendar library and supports drag and drop, time-based events, and is even responsive.

Mobile Reporting

You can now build reports that display all of your data on any mobile device, by using reflow table or column toggle. Reflow table wraps each column or changes to displaying multiple lines on very small screens. Column toggle allows you to specify the most important columns, and those which will be hidden as necessary on smaller screens.

Static File Upload

Files uploaded into shared components, plug-ins, or themes can be cached by your browser and are now referenced using relative file urls. This also allows you to upload a zip file and the contents of it will be automatically extracted, and relative file references will stay intact. Want to bundle up your files? No worries, you can also zip them all up and produce a single downloadable zip file.

Stay tuned for more about APEX 5.

It's a really cool thing.

Ciao for Now!

Wednesday Dec 31, 2014

Top 5 Oracle Database Tech Releases of 2014

It was a great year for Oracle Technology...with so many great new features and products for Oracle DBAs, Data Scientists and Developers. Here's the Top 5 new technologies that we rolled out, with the resources you need to get started...from your friends here at the OTN Watercooler.

  • Oracle Database 12c -- ...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release supports Linux and Oracle Solaris (SPARC and x86 64 bit). See the full list of features with direct links to docs and resources. 
And if you're ready to start your upgrade journey to Oracle Database 12c, be sure to check out this Upgrade Starter's Guide and follow the Oracle Upgrade NOW blog
    • Oracle Database In-Memory -- Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with virtually any existing Oracle Database compatible application is as easy as flipping a switch--no application changes are required. It is fully integrated with Oracle Database's scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry.

      This whitepaper Oracle Database In-Memory gives you more detail about the new option available only in Oracle Database 12c, and if you want to get started, check out this article series:

    • Oracle Key Vault is a software appliance designed to securely manage encryption keys and credential files in the enterprise data center. It provides secure, centralized management of encryption keys and credential files including Oracle wallet files, Java KeyStores, Kerberos keytab files and SSH key files and SSL certification files.  Want to get started?  Here's what you need to know.

    • Oracle Big Data SQL -- Oracle's unique approach to providing unified query over data in Oracle Database, Hadoop, and select NoSQL datastores. Read more about why SQL is becomming the "GoTo" language for Big Data Analysis.

    • Oracle Oracle Zero Loss Recovery Appliance --Launched in October at OOW2014, The Oracle Zero Data Loss Recovery Appliance is a terrific addition to the Oracle Engineered Systems Portfolio. With its support for real-time redo transport, the appliance is designed to bring "Data Guard-like",  robust data protection for all the Oracle Databases in the data center. It's a sweet ride... Get the full story here.

      But as with most "Top" lists, there are many more items to include. So Special Mention goes to:

        JSON Support in Oracle 12c -- Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. You can project JSON data relationally, making it available for relational processes and tools. You can also query, from within the database, JSON data that is stored outside the database, in an external table. Get more information about JSON support in Oracle Database 12c. You can start with the XML DB Developer's Guide.

      • Happy New Year and

        Ciao for Now!


      Monday Oct 20, 2014

      Oracle Critical Patch Advisory -- October 15, 2014

      ATTN: Oracle DBAs: Oracle has published its Critical Patch Advisory Dated Oct 15, 2014.  Get the advisory here

      Here's what you need to know:

      This Critical Patch Update covers 154 new security fixes across a wide range of product families including: Oracle Database, Oracle Fusion Middleware, Oracle Java SE, Oracle Linux and Virtualization, Oracle MySQL, Oracle Hyperion, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, and Oracle Business Applications and more.

      REMEMBER: Critical Patch Update fixes are intended to address significant security vulnerabilities in Oracle products and also include code fixes that are prerequisites for the security fixes. As a result, Oracle recommends that this Critical Patch Update be applied as soon as possible. 

      Customers of affected Oracle products are strongly advised to apply the fixes that were announced in the Security Alert for CVE-2014-7169.

      ALSO NOTE: On September 26, 2014, Oracle released a Security Alert for CVE-2014-7169 "Bash" and other publicly disclosed vulnerabilities affecting GNU Bash. Read the GNU Bash Security Alert here.

      Get the list of Oracle products that include the Bash program here .

      Read the Oracle Security Blog here.

      Ciao for Now!


      Monday Sep 22, 2014

      OOW 2014 #CLONEATTACK Comes to OTN Lounge

      Yes, Monday, 9/29 from 3:30 - 5:00 We'll be hosting a #CLONEATTACK at the OTN Lounge in Moscone South Lobby.

      #CloneAttack is your chance to install a complete Delphix lab environment on your Windows or Mac laptop for you to play with and experiment at any time. Experts Kyle Hailey, Steve Karam, Adam Bowen, Ben Prusinski, and Tim Gorman will help attendees install virtual machine OVA files for the lab environment, and will work one-on-one with you to help get everything up and running, then to show you basic use-cases for cloning with Delphix.

      Bring your laptop, bring your VMware, and get some data virtualization into your virtual life!

      At the same time, #CloneAttack will be joined by #RepAttack by Dbvisit, where Arjen Visser, Jan Karremans, and the team will be helping you replicate Oracle to Oracle for zero downtime upgrades.

      If you want to learn more about "Living La Vida Oracle", read this blog from Oracle Ace Director, Tim Gorman.

      And if you want to get ready for #CLONEATTACK...Here's what you need:

        Mac: VMware Fusion (free trial version download)
        Win: VMware Workstation (free trial version download)
        Minimum 8 GB RAM onboard
        Minimum 2 Ghz CPU, preferably dual-core or better

      C'mon out!

      Ciao for Now,


      Wednesday Sep 17, 2014

      w00t! OOW 2014 RAC ATTACK Set Up Instructions

      Going to the RAC ATTACK at OOW 2014? We're meeting on Sunday 9/28 starting at 9:00 am at the Oracle Technology Lounge in the Moscone South Lobby. Here's the FIRST, NEXT and FINALLY information you need to be ready to learn more about Oracle 12c and Real Application Clusters.

      FIRST --The T-shirt:

      NEXT -- What to expect:

      Experienced RAC ATTACK volunteers will walk you through an installation of the Oracle 12c RAC environment on your laptop, explore advanced RAC related setup scenarios or work on solving more advanced RAC related challenges.

      During the workshop you will learn how to setup one of the most complex infrastructures on your laptop. You will learn how to configure and clone virtual machines, how to create and setup internal and external virtual networks, create different storage types, setup a local DNS server and other challenging components.

      After this workshop you will know how to setup a test/sandbox environment for virtually any product.

      Attendees have 3 options for exercises during the RAC ATTACK:

        1. RAC 12c installation - participants install Oracle Virtualbox, Oracle Linux, Oracle 12c RAC and configure those components to work together.
        2. RAC 12c advanced tasks - for those who have 12c RAC on their laptops already the workshop has to offer to go through a set of advanced scenarios. Each scenario focused on a particular RAC 12c features to learn and explorer.
        3. RAC freestyle - join in groups to work on RAC related challenges.

      FINALLY: Set up your laptop

      To participate in the workshop, participants need to bring their own laptop. Recommended specification:
        a) any 64 bit OS that supports Oracle Virtual Box.
        b) 8GB RAM, 45GB free HDD space.

      To save time we suggest that you pre-download Oracle Database 12c ( and Grid Infrastructure ( for Linux x86-64 from the Oracle Technology Network. GET IT HERE.

      Want to know more about the Oracle RACSIG? HIT THIS

      Ciao for Now,


      The OTN DBA/DEV Watercooler is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.


      « April 2015