In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Month: January 2023
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.