firstname.lastname@example.org / Blog de Tecnologías Oracle desde 2009, San José, Costa Rica, La adquisición de cualquier conocimiento es siempre útil al intelecto, que sabrá descartar lo malo y conservar lo bueno. Leonardo Da Vinci /
Larry Ellison to Graduates: ‘Live Your Dreams, Not the Dreams of Others’
Todos los Sábados a las 8:00PM
Soy parte de ULACIT
Ahora a suscribirse y seguir el contenido de este blog.
jueves, 1 de septiembre de 2016
August 2016 Edition: OTN Database Community Newsletter
Getting ready for the newest features of Oracle Database 12c? With Oracle
OpenWorld just around the corner, you can expect alot of great
information about the database platform, technologies and tools will be
rolling out soon.
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 the
calendar of upcoming events including registration for Oracle OpenWorld
2016 and On Demand streaming for Keynotes in case you can't attend.
Next, dig in to the feature articles from the OTN Community focused on
PL/SQL techniques, what's new with APEX, 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.
Featured Book From OTN Community:
Real World SQL and PL/SQL: Advice from the Experts - 1st Edition
AVAILABLE! -- Real World SQL and PL/SQL -- This book was written by 5
Oracle ACE Directors, all with 20+ years of experience working with the
Oracle Database, and they clearly all love sharing their knowledge. Thank
you Brendan Tierney, Arup Nanda, Heli Helskyaho, Martin Widlake and Alex
Nuitjen for the fantastic book, and special thanks to Chet Justice (Oraclenerd),
and Oracle ACE Director, as the technical editor. Can't wait to read the
forward by Tim Hall, Oracle ACE Director. Get the book Now.
OTN Virtual Summit | ON DEMAND| Watch Today
Technology Network Virtual Summit presents indepth presentations and
Hands-On-Labs on topics covering Oracle Database 12c Advanced Options,
new generation application development tools and techniques, DevOps using
the Oracle Database Cloud, Big Data and Business Analytics in the Cloud
as well as sessions dedicated to the most recent capabilities of Oracle
MySQL for Oracle DBAs and Developers. Watch the Latest Database
Check Out Oracle Live SQL
Live SQL gives you an easy, online way to test and share SQL and PL/SQL
application development concepts. Get instant access to the Oracle
Database and learn from a collection of community scripts and structured
tutorials. See Live SQL here.
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
Oracle KeyVault 12.2 is a
major feature release with advanced features such as Endpoint
enrollment automation leveraging RESTful interfaces, Endpoint platform
support extended to AIX and HP-UX (IA) in addition to existing support
for Linux and Solaris, Modern hardware support (OL 6.6 as base platform),
management reports for endpoint activity, user activity, and
entitlement. Download it now. Oracle Key Vault
is the place to go.
Oracle SQL Developer is a
complete end-to-end development platform for your PL/SQL applications
that has it all. Release 4.1.3 includes an updated version of SQL
Developer Data Modeler (v4.1.3) and Oracle REST Data Services (3.0.4).
Also includes CVS version control support out-of-the-box, no longer
requires check for updates/install. Check it out now. Oracle SQL Developer
is the place to go.
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.
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
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.
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
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
See Bryn's Blog, OTN Community Cast video,
and Transforming whitepaper
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
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
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
Sample Schemas: Oracle Database sample
schemas are installed with Oracle Database Enterprise
Use these schemas to learn SQL language concepts.
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
Database Documentation: Oracle Database Development
Guide This guide covers database development fundamentals,
SQL for developers and PL/SQL development tips plus advanced topics for
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.