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 »
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...
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 »
Have you ever wanted to generate a list of dates using Oracle SQL? In this little tutorial I will show you three different ways you can do this with a simple SQL query. I will also show a practical use of it. Read More »
If you are new to SQL, you still might have heard about aggregate functions. These are functions that can be used inside a SELECT query. In this tutorial we are going to look a bit on what it is, and how it can be used. Read More »
In this video I will show you how you can use PL/SQL Developer from Allround ... Read More »