In this post we will look at the data load from local file feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored locally or in the cloud, all without writing any code.
Oracle Autonomous Database: Accessing & Using Database Actions
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.
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)
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.