OTN Database Application Developer Newsletter

February

2017

Oracle Database Applications Developers:

Oracle is building a global developer community--and you're invited to join! Visit the new Oracle Developer Blog where expert developers post indepth articles on Oracle development tools, language support, architecture and implementation of the most modern, easy and open applications in the industry.
This month's DAD newsletter has an updated list of downloads-- so make sure you are up to date on all your Oracle applications. Then check out tutorials and Hands on Labs offered by OTN to help you hone your development skills.
Next, dig in to the feature articles from the OTN Community focused on Developer technologies, PL/SQL techniques, Oracle's Analytics 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 join the Oracle Developer Facebook page or follow @OTNDBDEV on Twitter to get the latest downloads, tutorials and community updates.

Featured Download From OTN Community: Oracle SQL Developer Command LIne

The Developer's Choice: Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience, all while also supporting your previously written SQL*Plus scripts. Get Oracle SQLcl 4.2 here .

Oracle Code 2017: Building A Global Developer Community

Ready to meet with Oracle developers around the world? The Oracle Code Developer series starts on March 1st in San Francisco followed by Austin on March 8th, New York on March 21st and then moving on to 18 more cities around the world. The agenda includes keynotes from industry experts in many aspects of advanced software development plus Hands on Labs and and technology break out sessions covering everything from Microservices to Big Data application development. This conference series is presented by developers for developers, and is coming to a city near you. See the agenda, Meet the developers behind the series and register for Oracle Code 2017 here.

Now Available on GitHub: Oracle Database Programming Interface for C (ODPI-C).

ODPI-C is a C library that simplifies the use of common Oracle Call Interface (OCI) features for Oracle Database drivers and user applications. It sits on top of OCI and offers an alternative programming experience. ODPI-C is a refactored and greatly enhanced version of the DB access code we have been successfully using with the current node-oracledb driver. ODPI-C will allow us to more quickly standardize the DB access experience across multiple drivers, and provide easier maintenance through code reuse.
There is active work on updating the Node.js node-oracledb and Python cx_Oracle drivers to use ODPI-C.
Read more about the new features in ODPI-C and download it here.

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

Oracle Code Developer Events - 18 Cities | Worldwide
San Francisco, March 1 | Austin, March 8 | New York, March 21 | Washington DC, March 27 |
See the agenda and register for a city near you.

KSCOPE 17 - June 25-29, 2017 | San Antonio, TX | ODTUG User Group annual conference and training event features technical sessions for DBAs, Developers and IT professionals. Register for KSCOPE here .

IOUG Collaborate 2017 - April 2-4, 2017 | Las Vegas, NV | Learn from technology experts on all options and features of Oracle Database 12c, Oracle Cloud Services, Big Data, and more. Attend sessions covering key business issues and technologist journeys and exclusive IOUG attendee only activities, hands-on labs from Oracle ACEs, the Strategic Leadership Program and more. Register for Collaborate here.

Introduction to Python for PL/SQL Developers -

Arup Nanda, Oracle Ace Director and SQL expert, presents an easier way to learn Python by comparing and contrasting to PL/SQL. Each section provides an indepth article with exercises, a quiz, a handy summary and a link to a video presentation of the section by Arup Nanda.
See the Introduction to Python for PL/SQL Developers article series here.

The NoPLSql vs. Thick Database Approaches -

In this online presentation, Toon Koppelaars, Consulting Member of Technical Staff in Oracle's Real-World Performance Group, describes twodifferent approaches: The NoPlsql (the database as a persistence layer, using only naive single-row SQL statements) vs. the Thick Database approach (the database as a processing engine; using a combination of sophisticated set-based SQL statements and PL/SQL to implement all business logic inside it). “No business logic in the database” advocates take note: the Thick Database approach gets the task done with far less database work than the NoPlsql approach. Watch the PLSQL vs. ThickDB experiment here. See Bryn Llwewllyn's Blog for more on the Thick Database approach.

12 Things Developers Will Love about Oracle Database 12cR2 -

In this article Chris Saxon, SQL expert and Oracle technology advocate, presents the 12 things developers will love about Oracle Database 12cR2 such as enhanced JSON support, Listagg improvements, support for longer namespaces, single statement table partitioning and more.
See Chris Saxon's Blog, and the Magic of SQL show on Youtube here.

Installing and Setting Up OracleR Server on Oracle Database Cloud Service -

Apart from SQL, one of the most popular languages used for analyzing data is the R language. Most people who use this language also use RStudio as their development tool. But the R language has some limitations and your developers and data scientist will quickly encounter them. But as more and more of us are moving to having our data on the cloud, how can we utilize R on our cloud services? Oracle ACE Director Brendan Tierney walks through installing and configuring RStudio Server on an Oracle Database Cloud.
EXTRA CREDIT: Checkout the Oracle Database Virtual Machine 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 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.