Wednesday May 06, 2015

Schemaless Application Development with ORDS, JSON and SODA

There's a lot to talk about when it comes to JSON support in Oracle Database 12c. A big part of that story is Oracle REST Data Services 3.0, which was just released on May 4th. But there's more to it. Oracle 12c has a key set of API's:  Simple Oracle Document Access (SODA).   And it's important.

Here's the deal:

Oracle Database supports storing, indexing and querying JSON documents in the database. But the picture is completed by document-centric API's for accessing JSON documents.

Introducing Simple Oracle Document Access (SODA)

SODA, the set of APIs specifically designed to support schemaless application development.

There are 2 SODA implementations:

  1. SODA for Java-- a programmatic document-store interface for Java Developers that uses JDBC to communicate with the database. SODA for Java consists of a set of simple classes that represent a database, a document collection and a document. Methods on these classes provide all the functionality required to manage and query collections and work with JSON documents stored in an Oracle Database.

  2. SODA for REST-- a REST-based document store interface implemented as a Java servlet and delivered as part of Oracle REST Data Services (ORDS) 3.0. Applications based on SODA for REST use HTTP to communicate with the Java Servlet. The SODA for REST Servlet can also be run under the database's native HTTP Server. HTTP verbs such as PUT, POST, GET, and DELETE map to operations over JSON documents. Because SODA for REST can be invoked from any programming or scripting language that is capable of making HTTP calls, it can be used with all modern development environments and frameworks.

Want to see it in action?

Check out the oracle/json-in-db repository on Github. You'll find downloadable and installable demonstrations for the JSON capabilities of Oracle Database and later.

And get more details about Oracle as a Document Store from OTN.

Join the ORDS discussion space on the OTN Community Platform here.

Ciao for Now!

Monday May 04, 2015

SQL Developer 4.1 - Oracle REST Data Services 3.0 are HERE!

Big Day Today for the Oracle SQL Developer Tools team as they launch Oracle SQL Developer version 4.1, Oracle SQL Developer Data Modeler 4.1, and Oracle Rest Data Services 3.0.

Here's What You Need to Know:

Oracle SQL Developer 4.1 and SQL Developer Data Modeler 4.1 let customers design, develop, and deploy applications running on premises or in Oracle Database Cloud Services. And SQL Developer 4.1 sports a new interface for DBAs to observe critical metrics in real-time around IO, networking, wait events, storage, and more.  And here's how SQL Developer now supports Public Cloud Services-- It has  a one-button-click solution for copying on-premises Oracle Databases to the Oracle Database Cloud Service. So you just  right-click on a 12c Multitenant Pluggable Database and choose to either move, or copy to the Cloud Service. When the operation is complete, the database is automatically made available in the Oracle Database Cloud Service.

And one more thing:  Oracle SQL Developer offers tighter integration with Oracle REST Data Services. Starting with the 4.1 release, SQL Developer can now install, configure, and run Oracle REST Data Services version 3.0 without any additional downloads.

And speaking of Oracle REST Data Services, ORDS has been gaining momentum since first released in 2010, and release 3.0 is by far the most significant. Prior to release 3.0, ORDS required you use Oracle Application Express (APEX) to define your RESTful web services.  Now with ORDS 3.0 you can alternatively or additionally define RESTful web services from SQL Developer. ORDS enables a consistent RESTful interface to Oracle Database's relational tables, JSON document store, and also enables access to Oracle NoSQL Database tables. Likewise, access to the JSON Document Store is seamless when provided by ORDS, whether the store is Database 12c or NoSQL 3.0.

This was an important aspect of ORDS because Oracle is committed to supporting both RESTful services and JSON, and has made storing native JSON in the database a key feature of Oracle Database 12c. Oracle Database 12c is now a JSON document store that can be accessed using the Simple Oracle Document Access (SODA) API.

So that's the news today.

Additional Information

Ciao for Now!


Thursday Apr 30, 2015

What's Planned for the FREE Virtual Technology Summit on May 5th

The Oracle Technology Network is hosting a phenomenal agenda at the Virtual Technology Summit on May 5, 2015 (9:00 am PT to 12:30 pm PT). You should go. Here's why:

Just wait until you see the presentations we’ve put together for our event. We have a dedicated track on Big Data, where we’ll be showcasing the new Big Data Lite virtual machine. We have exercises designed to help you learn how to use Oracle Big Data SQL, and the Oracle Data Loader for Hadoop + Oracle Connectors for HDFS to get your Big Data implementations rolling.  Plus the team will be showcasing new functionality in the Oracle Advanced Analytics  and Oracle R Enterprise.  It's going to be a Really Big Show. 

And the Developer Track is huge too.  Check out the 2 full tracks covering hot Applications Development topics.  We’ll  cover our traditional database Application development tools like SQL Developer and Application Express…both of which have big announcements…So watch this space for news on that on MONDAY MAY 4th...

And it's not all work. Get ready for some Fun…Fun with Functions that is. Steven Feuerstein makes it so easy to master PL/SQL.  And don’t miss the SQL Magic show hosted by our SQL magician and developer advocate, Chris Saxon… He says Presto and Ta-DAA at least 4 times during his session! 

Did you say FUN?

So here's what I want you to do:

% Register NOW for the Free OTN Virtual Technology Summit. And you can invite as many friends and coworkers as you'd like.  

% Install the Virtual Machine and the scripts so you can follow along on all the exercises.

% Type "See you there!" in the comments below to receive special recognition when you log in to the event.

Ciao for Now!


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!



      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.


      « July 2016