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.
Posts
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.
Monitoring Integrations in Oracle Integration Cloud (OIC) – Pt3
In this post we will explore the out-of-the-box email monitoring available for integrations in Oracle Integration Cloud.
Monitoring Integrations in Oracle Integration Cloud (OIC) – Pt2
In this post we will explore the out-of-the-box design-time metrics available for integrations in Oracle Integration Cloud.
Monitoring Integrations in Oracle Integration Cloud (OIC) – Pt1
In this post we will explore the out-of-the-box dashboard monitoring capabilities for integrations in Oracle Integration Cloud.
Oracle JET – Getting Started
Oracle JET is an open source toolkit developed by Oracle which can be leveraged to build enterprise applications in JavaScript. It's important to identify that Oracle JET is not a framework, only a toolkit. ...But, what does that mean? well, you can't just swap out Angular or React (or the many other JS Frameworks) for Oracle JET! Instead, application developers can pick and choose thoroughly tested, modular components from the toolkit (cookbook!) that leverage JQuery and KnockoutJS and weave them into their application development - code snippets, if you like. Recent versions of JavaScript, HTML5 and CSS3 architecture principles are quickly established.