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 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)