A new school term, some more blog posts.

How many tickles does it take to tickle an octopus?

Tentacles!

Summer is officially over, so pull up a chair and read some of the blogs that have been published over the summer and watch some videos!

Blogs of the week

Error!?! What’s going in APEX? The easiest way to Debug and Trace an Oracle APEX session

Dimitri Gielis asks, ‘What’s going on in APEX?’

He finishes by saying, “I hope by this post you see the light when you are in the dark. Let the force be with you :)”

2. DevOps in OAC: Scripting Oracle Cloud Instance Management with PSM Cli

Francesco Tisiot shares his thoughts on

Development Isolation
Feature-Related Instances
PaaS Service Manager Command Line Interface
Installing and Configuring PSM Cli
Working With PSM Cli
Creating an OAC Instance

3. Building interactive charts and tables in Power Point with Smart View

Gary Crisci asks, “Do you get tired of recreating the same PowerPoint decks each month when your numbers change? Wouldn’t it be great if you could just push a button and have the numbers in your ppt slide update to what is in the database? Wouldn’t it be even better if the data was used in visually rich MS Office objects such as tables and charts? And, wouldn’t it be awesome if you could interact with the data in real time during your presentation?”

4. Oracle EPM Cloud 101: Infrastructure Concepts

Opal shares this blog which is part of a series that covers the basic concepts of Oracle EPM Cloud.

5. PaaS Options To Extend Oracle Cloud Applications

There is no single answer to what PaaS components are needed. Understanding the customer challenges, and how they use the Cloud Applications, means we can find the right solution for them. Watch this video for more information.

6. 18c database creation on Windows

Connor McDonald says, “Hopefully you’ve followed my very simple and easy guide to downloading the 18c database software for Windows. But of course, software on its own is not much use – we need a database! So let’s get cracking and create one.”

7. Log more change, easier to process change

Peter Scott begins by saying, “This is part one of a two part blog that’s going to talk about bright shiny things like Oracle GoldenGate Big Data streaming my ERP system changes through Kafka to cloud (in this case an Oracle Cloud App). ”

8. Date Partitioning and Table Clustering in Google BigQuery (and Looker PDTs )

Mark Rittman begins by writing, “Google BigQuery is a data warehousing-orientated “table-as-a-service” product from Google Cloud Platform that, like Oracle Exadata, optimizes for full-table scans rather than selective row access and stores data organized into columns, rather than rows, to align better with filtering and aggregation workloads associated with data warehousing workloads.

BigQuery charges by amount of data stored in your tables and the data you’ve read in executing SQL queries against those tables, so BI tools such as Looker that work efficiently with BigQuery only request the columns they need when querying BigQuery datasets rather than running a SELECT(*) and throwing away what’s not needed.

To illustrate this let’s run a query…” Read the full blog for more.

9. JSON Patch, Merge Patch, and Redact features in Oracle 18c

Marc starts by writing, “These days, I am looking into the latest additions to SODA in Oracle Database 18c, in particular the REST implementation available via Oracle REST Data Services (ORDS) : SODA for REST.

I wrote once about SODA in the past (see here), to give a preview of JSON filter expressions before their official documentation in release 12.2.

Before looking more closely at the features mentioned in the title, I’ll set up a little SODA collection.”

This week on Twitter

Ric Van Dyke tweeted SQL Developer: Renaming Columns in the cloud or not

Connor McDonald shared:

A silent movie on joins: