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
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)
Oracle CloudWorld 2022
In this post, I share some thoughts, observations and memories from Oracle Cloud World 2022.
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.
Oracle Hospitality Integration Platform (OHIP) New Release!! (22.1.1)
I've recently been working with Oracle OPERA Cloud. This is Oracle's Hospitality Property Management (PMS) offering. More specifically, I have been focusing on Oracle Hospitality Integration Platform (OHIP) which provides a rich set of 3000+ endpoints for integration into and out of OPERA Cloud. It only feels like yesterday that I posted about Oracle Hospitality's latest OHIP release (you can read that one here).. well... I'm back again to talk about yet another!! Oracle have completed their second Oracle Hospitality Integration Platform (OHIP) release of the year (22.1.1) and this time, we see a really awesome feature.
Oracle Hospitality Integration Platform (OHIP) Developer Portal gets a facelift!!
I've recently been working with Oracle OPERA Cloud. This is Oracle's Hospitality Property Management (PMS) offering. More specifically, I have been focusing on Oracle Hospitality Integration Platform (OHIP) which provides a rich set of 3000+ endpoints for integration into and out of OPERA Cloud... it truly does an awesome job at simplifying integration.
OIC Integration Lifecycle Using REST Endpoints
Out-of-the-box, Oracle provides a bunch of REST endpoints available to interact with your Oracle Integration Cloud (OIC) instance or the components in which you have built. In this post, we will look at how we interact with an OIC integration using the available REST endpoints throughout it's lifecycle. This post will not cover all available … Continue reading OIC Integration Lifecycle Using REST Endpoints
Oracle Integration Cloud (OIC) & octet-stream MIME-type
I was recently working on an integration in Oracle Integration Cloud (OIC) which leveraged REST APIs exposed from Oracle HCM. I needed to retrieve details from the REST endpoint in the image below. The overall solution would take this REST response and write the data to an XML file to be consumed by another system. … Continue reading Oracle Integration Cloud (OIC) & octet-stream MIME-type
Oracle Integration Cloud (OIC) UiPath Adapter
The purpose of this blog is to act as a follow on to my last post where we defined and connected a UiPath robot to UiPath Orchestrator. If you have not seen that yet then you can find it here: UiPath - Creating a Robot in Orchestrator. This blog will describe how you can use … Continue reading Oracle Integration Cloud (OIC) UiPath Adapter
AMY SIMPSON-GRANGE - BLOG 