How many tickles does it take to tickle an octopus?
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
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 :)”
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
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?”
Opal shares this blog which is part of a series that covers the basic concepts of Oracle EPM Cloud.
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.
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.”
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). ”
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.
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:
UKOUG shared the Oracle Scene article submission deadline
Videos such as:
OBIEE 12C: BI Repository (RPD)
Oracle JET Tip: How to Work with Multiple Oracle JET Applications