Database actions can be accessed for Oracle Autonomous Database. In this post we will look at what Database Actions are, how to access/use them and also how to grant access to other users to make the most out of the features available.
Author: Amy Simpson-Grange
Connecting to an ATP Database in Oracle Cloud
In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Creating an ATP Database in Oracle Cloud
In this post, I document the steps to help you create your own Oracle ATP Database Service.
Oracle PL/SQL: GROUP BY
I recently wrote, HERE, how I regularly see commonly asked questions appearing in forums relating to the same topic. Like with SELECT INTO from my previous posts, I also see lots of questions about the correct usage of the GROUP BY clause and so I figured that I would write up an explanation of how to properly use this and then, again, I can reference this post's URL in response to questions on this topic!
ORACLE PL/SQL: SELECT INTO Common Errors
In my previous post, I explained how to correctly use the Oracle PLSQL SELECT INTO statement. Here, I will expand on that further by describing common error messages you may see when using SELECT INTO, what you should do about them and most importantly, how you should prepare to handle them in your PLSQL logic.
Oracle PL/SQL: SELECT INTO
Like many in the Oracle community, I occasionally find myself looking through forums and helping out where I can. I consistently see some basic questions cropping up in forums like StackOverflow, often the same question over and over again - one of which is regarding the "SELECT INTO" statement. I have found myself writing responses to questions about SELECT INTO statements many times and so I figured that I would write up an explanation of how to properly use this and then I can reference this post's URL in response to questions on this topic! Side note: It's been quite some time that I used PL/SQL and really enjoyed spinning up an oracle database in my free tier account and writing this post - perhaps expect a few more similar style posts alongside my usual content (maybe more commonly asked forum topics)
5P’s of Presenting
A short post on a different topic to my normal posts. I was archiving some documents on my laptop and came across a short presentation deck I had made during a presenting course. I am writing this information here in a blog post so that I can always easily refer back to it and so that I can share the information with others!
UKOUG BREAKTHROUGH ’22
I’m speaking at #UKOUGBreakthrough22! Join me in Birmingham where I will be discussing Oracle Integration Cloud. Get your tickets now: https://bit.ly/3yEL6qd
Oracle CloudWorld 2022
In this post, I share some thoughts, observations and memories from Oracle Cloud World 2022.
Monitoring Integrations in Oracle Integration Cloud (OIC) – Pt4
In this post we will explore the out-of-the-box monitoring available for integrations in Oracle Integration Cloud.