OTN Database Application Developer Newsletter

View this message in a Web browser.

Database Application Developer Newsletter

OTN DBADEV

October

2016

Oracle Database Applications Developers:

Are you Ready for Oracle Database 12c Release 2? How about all the new developer technology updates that are now available?

Start with a quick review of the most recent downloads to make sure you are up to date on all your Oracle applications. Then check out sessions and interviews from Oracle OpenWorld 2016 to make sure you have the big picture.

Next, dig in to the feature articles from the OTN Community focused on Developer technologies, PL/SQL techniques, Oracle's Big Data portfolio, Oracle's Docker catalog and Oracle's Database Cloud Services.

If you want to continue to master your database application development methods, read on... and join the OTN Community or Follow @OTNDBDEV to get the latest downloads, tutorials and community updates.

Get Oracle Database 12c Release 2 via Database Exadata Express Cloud Service

The latest innovations for Oracle Database are now available in the cloud first. Developers have full access to all Oracle Database options for development and test, while IT can validate database migrations, load test, or performance test existing databases before production deployment. If you're looking for Oracle Database 12c Release 2 features, it will be available in the Cloud first on the Oracle Database Exadata Express Cloud Service-- a full Oracle Database experience delivered as a managed cloud service running on Oracle Exadata and provisioned in minutes. Get the Oracle Exadata Express Cloud offering for just $175/mo here.

Featured Demonstration From OTN Community:

SEE IT HERE IN ACTION!!! -- Oracle Database Exadata Express Cloud Service--First Look See this live demonstration of the Oracle Database Exadata Express Cloud Service. This 3 minute video demonstration from the Oracle OpenWorld Database general session gives you a quick view into the advanced capabilities we've built into Oracle Database 12cR2. See the Live Cloud Demo here.

Oracle Scores Highest in 3 of 4 Use Cases -- Gartner Critical Capabilities Report

New products for operational DBMS use cases are maturing, challenging data and analytics leaders to select the right technology. This research and companion Magic Quadrant report combine vendor capabilities and client implementation experience to identify products that meet requirements. Find out more in the latest Gartner Critical Capabilities for Operational Database Management Systems report .

Why Do Developers Love Oracle Database? JSON.
Oracle Community Cast --Live from Oracle OpenWorld 2016

The OTN Community Cast set buzzed with activity as we interviewed Oracle ACE Directors, Oracle Experts and even a few Oracle Software engineers. Watch this interview with Beda Hammerschmidt, an Oracle developer, talking about JSON support, and what he thinks is the most important technology that developers need.

— Laura Ramsey, Community Manager, Database and Developer Community, @OTNdbdev

DOWNLOADS

Download: Oracle Database 12c Release 2

Oracle Databases help customers lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds and engineered systems like Oracle Exadata and Oracle Database Appliance. Proven to be fast, reliable, secure and easy to manage, Oracle Database 12c is ideally suited for all types of database workloads including enterprise applications, data warehouses, and big data analysis. Download Oracle 12c here. All updates to Oracle Database 12c are delivered Cloud First. Get Oracle Database 12cR2 via the Oracle Database Exadata Express Cloud Service here.

Download: Node-oracledb 1.11

node-oracledb 1.11 for Node.js is available on Github and NPM. The driver works with Node 4.2 LTS and 5.0 in addition to 0.10 and 0.12. (Note: a compiler with C++11 support is required.) The add-on is maintained by Oracle, and is under active development on GitHub and available on NPM. Find out more from the Scripting and Oracle blog by Christopher Jones, or visit the Node.js Developer Center on OTN. See the Free Oracle Instant Client Libraries used by node-oracledb here.

Download: Oracle SQL Developer 4.1.5 + 4.2 Early Adopter NEW!!

Oracle SQL Developer is a complete end-to-end development platform for your PL/SQL applications that has it all. Release 4.1.5 includes an updated version of SQL Developer Data Modeler (v4.1.5) and Oracle REST Data Services (3.0.8). Also includes CVS version control support out-of-the-box, no longer requires check for updates/install. SQL Developer and Data Modeler Version 4.2 Early Adopter is also available. Check it out now. Oracle SQL Developer is the place to go.

Download: Oracle Big Data SQL and Big Data Prep Cloud Services

Big Data SQL dramatically expands Oracle's reach into the Big Data space by enabling Oracle SQL on Cloudera and Hortonworks Hadoop, both on non-engineered systems as well as Cloudera on the Oracle Big Data Appliance. Use the full power of Oracle SQL to analyze all of your data and extend extend Oracle Database-level security to Hadoop and NoSQL. And if you are starting to play with Big Data in the Cloud, Check out Oracle Big Data Cloud Services here. More information can be found on the Oracle Technology Network.

Download: Oracle Rest Data Services 3.0.8

Oracle REST Data Services (ORDS) makes it easy to develop REST interfaces for relational data in the Oracle Database 12c JSON Document Store and Oracle NoSQL Database. ORDS is available both as an Oracle Database Cloud Service and on premise. ORDS can now be installed independently of Oracle Application Express. See the installation guide and download here: Oracle REST Data Services and the list of updates here: New Features in Oracle REST Data Services.

Download: Oracle Application Express 5.0.3 is Here

Oracle Application Express 5 is now generally available. The result of a two and a half year engineering effort, it represents the greatest advancement of Oracle Application Express (APEX) in its 10-year history. Oracle Application Express 5 enables customers to develop, design and deploy elegant, responsive, database-driven desktop and mobile applications using only a browser. Get the installation guide and download here: Oracle Application Express 5.0 and the list of updates here: Oracle Application Express 5.0 Release Notes.

Download: Docker Files --Oracle Database and More

Oracle has released Docker build files for the Oracle DAtabase on GitHub. The Docker technology is based on the Linux containers capabilities, so using these build files, you can place the Oracle Database in a container for development and testing environments. We have a quick guide, Installation zip files from OTN or if you prefer, you can get the directly from GitHub. For all the details, see Gerald Venzl's Blog, or visit the Oracle Docker Builds on GitHub here.

UPCOMING EVENTS

OTN Virtual Summit On Demand - Anywhere | Anytime
Attend Sessions covering Oracle Cloud Services and Business Analytics On Demand.

Sangam16 Tech Conference - November 11-12, 2016 | Bengaluru Electronics City| SANGAM is the largest annual Independent Oracle Users Group Conference in India. @ days of hands on labs and technical sessions. Register Now for SANGAM16

UKOUG 2016 Tech Conference - December 5-7, 2016 | Birmingham, UK | Join the largest gathering of Oracle Technology professionals in the UK for education, knowledge sharing and planning for the future. Register Now for UKOUG Tech 2016

RMOUG Training Days 2017 - February 7-9, 2017 | Denver - Rocky Mountain Oracle User Group Training Days event features 30+ technical sessions for DBAs, Developers and IT professionals. Register for RMOUG here.

Worldwide Oracle Developer Events Oracle hosts Developer Days, Cloud Summits and Code sessions worldwide. Check the Schedule to find an event near you.

DBDEV'S CHOICE: FEATURE ARTICLES

Analyzing The Panama Papers Using Oracle Spatial & Graph -

Robin Moffatt, Oracle Ace Director and business analytics expert, examines an interesting approach to mapping large datasets using oracle Spatial and Graph. In addition to being an elegant approach, the article presents a very intriguing dataset: The Panama papers.
See the OTN article on Oracle Spatial and Graph capabilities here.

Transforming One Table to Another: SQL or PL/SQL -

Bryn Llewellyn, Oracle Distinguished Product Manager and PL/SQL expert, examines alternative solutions to a well-known problem: How to compute non-overlapping RowID ranges that completely cover a nominated table and that all contain, as nearly as is possible, the same number of rows. The paper is based on community input from experts--the story of how the solution came to be is as interesting as the paper itself.
See Bryn's Blog, OTN Community Cast video, and Transforming whitepaper here.

Query Across Big Data Stores with Oracle Big Data SQL -

The Big Data engineering team at Oracle is rolling out compelling, extensible and high performance solutions. Do you understand your data? Are you starting to roll out your Big Data Strategy? What tools do you need and what is the best approach to finding and integrating Big Data? This set of Oracle Big Data resources will get you on the right track. EXTRA CREDIT: Checkout the Oracle Big Data Virtual Machine or Download Big Data SQL from the Oracle Technology Network.

Getting Started with Oracle Database Cloud Services -

Oracle Database 12c was designed from the very beginning to support the extraordinary performance, scalability and security requirements that cloud deployments demand. Visit the Oracle Database Cloud Services Community to learn about the capabilities of Oracle Database 12c in the cloud and how it establishes the foundation for security and performance for the entire Oracle cloud application portfolio. Follow this Database Cloud Services Community on OTN for tips and expert advice on getting started on the Oracle Cloud and what's in store in the Oracle PaaS portfolio. Sign up for a FREE CLOUD TRIAL today.

MORE VIDEO ON ALL THESE TOPICS AND MORE: @otndbdev on YouTube

OTN Database Community has an extensive set of playlists and interviews with Oracle technology experts. Visit the Oracle Database Community Youtube Channel here.

TRAINING | RESOURCES | Etc.

Oracle Database 12c: Introduction to SQL: Learn how to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Register for the SQL session here.

Oracle Database 12c: Sample Schemas: Oracle Database sample schemas are installed with Oracle Database Enterprise Edition 12c. Use these schemas to learn SQL language concepts.

Oracle Database 12c: Program with PL/SQL: Explore the benefits of PL/SQL and the basics of developing stored procedures, functions, packages and more. Register for the PL/SQL session here.

Oracle APEX Training On Demand from Oracle University:
Oracle Application Express Workshop 1; Oracle Application Express Workshop 2
Learn how to develop Database-centric web applications quickly using Oracle Application Express.

Oracle Database Documentation: Oracle Database Development Guide This guide covers database development fundamentals, SQL for developers and PL/SQL development tips plus advanced topics for applications developers.

Oracle Cloud Documentation: Oracle Database Cloud Service Development Guide An overview of application development tools and concepts for developing and deploying cloud-based applications. Includes additional resources with information about upgrading and useful tips for compatibility and interoperability between Oracle Database releases.