Latest news and blogs…

A few of the latest for your enjoyment…

Blogs of the week

1. Oracle JET – How To Reference JavaScript Module in HTML

Andrejus Baranovskis says, “I will explain how to reference JavaScript module function in Oracle JET HTML. In previous Oracle JET versions, we were using $root to access parent appController module. Syntax $root looks a bit like magic, it is better to reference module through a predefined variable. I will show you how.”

2. Exadata, Indexes and Performance in the cloud or not

Ric Van Dyke writes, “This year I’ve been on a gig working with a good sized Exadata implementation.   I really don’t know how big it is, my job is to tune queries not the database.   Before this gig I’d only done a little bit of work on Exadata and wasn’t well aware of the system.  Yes I knew the technical aspects of how Exadata worked, the storage cells, offloading, and such.  But to work with it day after day is something much more. Indexing is a hot topic around Exadata.  There are some who think there shouldn’t be any indexes at all on an Exadata system.  That is likely a bit extreme.  Fewer indexes for sure.  Primary Keys must have them and Foreign Keys really should.  Other indexes that would be created for performance might not be a good idea. There are two reasons of this…”

3. What version is my RAD stack?

Scott Wesley began his blog with, “A common follow up clarification on forums is regarding the version of the relevant tool.
Questions relating to Oracle APEX could be impacted by the APEX version, the database version, and perhaps the ORDS version – in addition to what browser is being used. The information on the RAD stack can be resolved in one (concatenated) SQL query. APEX was easy, there is a simple one row view, which ultimately translates to a function returning a literal.
Same with ORDS, I didn’t even bother with a scalar subquery when I put it all together. The Oracle database version had a few options, each with nuance.”

4. ADW – Loading data using Object Storage

Brendan Tierney shares, “There are a number of different ways to load data into your Autonomous Data Warehouse (ADW) environment. I’ll have posts about these alternatives. In this blog post I’ll go through the steps needed to load data using Object Storage. This might appear to have a large-ish number of steps, but once you have gone through it and have some of the parts already setup and configuration from your first time, then the second and subsequent times will be easier.”

5. DDL invalidates your SQL right ?

Connor McDonald links to this post first and foremost. Then goes on to say, “But I wanted to show a simple demo of how management of cursors continues to improve with each version of the database.

6. Oracle SQL for epm tips and tricks S01EP07

This blog, which is part of a series begins with, “Continuing our Oracle SQL for EPM series, today we’ll start to talk about analytic functions and how can we use them for more than “just” analytics. To start with, let’s talk about RANK().”

7. Oracle 19c Automatic Indexing: My First Auto Index (Absolute Beginners)

Richard Foote writes, “I am SOOOO struggling with this nightmare block editor but here goes. Please excuse any formatting issues below:

I thought it was time to show the new Oracle 19c Automatic Indexing feature in action and what better way than to go through how I created my first ever Automatic Index.”

8. Making Longer Lists

Stewart Ashton begins by saying, “For very long lists, we need the return values to be CLOBs. Alas, LISTAGG can only return VARCHAR2 lists, but XML and JSON aggregate functions can return CLOBs! As an exercise, I’ll start from ALL_OBJECTS: I want to make a list of all fully qualified object names for each object type. ”

This week on Twitter

Satyendra Pasalapudi tweeted a link to Getting Started with Oracle Functions and Object Storage

Javier Torres shared Oracle Demonstrates Innovation by the Boat Load at SailGP

Stories from and 

Videos such as:

PCMCS Implementation: Decisions and Challenges | Mike Killeen

ONLINE table maintenance WITHOUT upgrading to 12c Release 2