TJ Abrahamsen is the founder and author of OracleCoder. He has worked with Oracle since 1997. His expertise is with Oracle SQL, PL/SQL, and the latest years Java against Oracle databases. He loves teaching others, and like to share his thoughts, ideas, and experience on his blog.
By using the Oracle UPDATE statement, you can update one or multiple rows in a table. In this post we are going to look at how we can update multiple columns at the same, and a few ways to d... Read more
During my many years working with Oracle SQL, I have seen well written SQL queries from Oracle developers, as well as from Business Analysts. One thing I have seen a lack of (even among expe... Read more
Have you ever been in a situation where you have wanted to have replace several parts of a string into several other strings? In this tutorial I am going to show how to create a multiple rep... Read more
I work a lot with strings in PL/SQL, and recently I was working on a piece where I called a web service that returned information about longitude and latitude. In this post I will show you h... Read more
In this article I will be discussing commenting in PLSQL, and if we really need to care about commenting our code or not. During my years as a PL/SQL developer, I have seen many types of com... Read more
Having worked with SQL for so many years, I have definitely made up my mind about formatting SQL. I am a strong-minded person, and I have my own opinions. Most of these opinions are based on... Read more
Being totally fresh and new as any kind of developer can be pretty tough sometimes. Maybe you were just hired by a company and they promised you that they would teach you everything you need... Read more