A majority of the world is now on ‘Lockdown’/Self Isolating and Working From Home.
Take a break from it all and read something non-virus related – I’ve collated some of the latest blogs, news and videos.
Blogs of the week
Quanwen Zhao writes, “This post is focused on talking about how to optimize several SQL statements with LIKE expression in oracle database.”
Alex Nuijten starts with, “We had a problem with the awesome power that the Oracle database offers… or to be more specific the third party had a problem with that awesome power.”
He then goes through:
- Setting the Stage
- The Problem
- Our Solution
- Does it work?
Robin Moffatt writes, “COVID-19 has well and truly hit the tech scene this week. As well as being full of “WFH tips” for all the tech workers suddenly banished from their offices, my particular Twitter bubble is full of DevRel folk musing and debating about what this interruption means to our profession. For sure, in the short term, the Spring conference season is screwed— all the conferences are cancelled (or postponed).
But what about the future? No-one would ever want to take such a forced hiatus but what an excellent opportunity it is to take a step back and consider why we’re doing what we’re doing – and if we should go back to business as usual once things calm down.”
Stefan writes, “While doing a lot of Exadata Upgrades I get a problem on one of my DB nodes. The patchmgr works without an error and the Cluster starts up. I did a few checks including if all nodes have the same Kernel version but node01 has an older Kernel Version than the other nodes.”
Sven Weller explores the following:
- BITAND function but no BITOR function
- CAST with default on conversion error
- NEXT_DAY function parameter
- POWER (sql) = ** (plsql)
- ROUND_TIES_TO_EVEN function
- STANDARD_HASH function
Sean starts by saying, “Oracle enforces complexity rules for passwords when creating a database.”
Martin Giffy D’Souza begins by saying, “Starting with APEX 19.1 a new form type was introduced that replaces the old “Auto DML” model with much more robust functionality. Carsten Czarski wrote an in depth article about the new form regions and I suggest you read it before continuing with this post.”
Eric Erikson tells us, “Hopefully all Oracle cloud customers know about this topic, but maybe not. There is an Oracle website, cloudcustomerconnect.oracle.com, where users can post forum questions and submit enhancement requests (they’re called ideas). Oracle staff regularly review the items on CCC and comment. Also, there are webcasts announced via CCC on new product features and other items and the replays of these webcasts are also available.”
This blog says, we need to check our OAC version!
The easiest way of doing this is to use the OCI Analytics Console.
Click the relevant service name and see the verion number
This week on Twitter
Philippe Lions shared Oracle Analytics Cloud (OAC) – Using Usage Tracking
Francesco Tisiot shares these slides “Upgrade to OAS: Why and How?”
Videos such as:
Oracle Digital Assistant: Raw Payload Custom Component | Frank Nimphius
Openworld 2019: APEX Demonstration