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 replace function. Introduction Read More »
Being totally fresh and new as any kind of developer can be pretty tough sometimes. Maybe you were j...
In this little tutorial, I will show you how you can transpose columns into rows in Oracle, using SQ...
Have you ever been in a situation where you as a developer knows that your data is stored in your ta...
If you have worked with SQL for a while – you have most likely had a time where you wanted to ...
A while ago I wrote several similar articles on how to use the different Analytic functions in Oracl...
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 how I, in PL/SQL, created a function that returns any string between a given start string, and an end string. 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 comments, both good and bad. I will speak about some of the ways to comment that I have experienced. 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 experience, but some of them are..maybe…just traditions…sometimes driving colleagues nuts. 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 to know? Let me tell you something… The life in an IT department is very often a very hectic life, and things do not always turn out ... Read More »
In this video I will show you how you can use PL/SQL Developer from Allround Automations to import a text file, in my case a .CSV file into a simple table. This tool can be used for many types of data imports into an Oracle table. Read More »
OracleTuts.net has been around for a while. In this video I thought I should present myself, and tell you a little bit about myself, and my experience with Oracle. Read More »
This video will guide you through the steps needed to change the background color in Oracle SQL Developer. It will help you if you are tired of looking at the bright background the whole day long. Read More »
In this little tutorial, I will show you how you can transpose columns into rows in Oracle, using SQL. This post is a follow-up of a post where I showed how to transpose rows into columns. Read More »
Here are some interesting Oracle PLSQL and SQL Blog Posts that we found during week 10 of 2013: Top 10 Tips & Tricks for Oracle SQL Developer Oracle Magazine 15 Things You Should Know about the ORDER BY Clause Oracle FAQ’s Morgan’s Library Read More »