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 »
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 »
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 »
Hieararchies or trees in Oracle using CONNECT BY is actually pretty fun to work with. Lately I have been a real “tre-hugger”, since I have worked a lot with different tree structures, and downlines. I thought I wanted to share some of my latest experiences. In this tutorial we are going to look a little bit on downline hierarchies in ... Read More »
A long time ago I put together a tutorial (How To Use Oracle Analytic Functions in Oracle SQL) on how to use some of the more common Oracle Analytic Functions. In this tutorial I am going to discuss how to rank records in Oracle using the RANK() and the DENSE_RANK() analytic functions. I chose to put this in a separate post, since it ... Read More »
At my work I am responsible for generating data for 90% of our contests. Once in a while there are requests where they want to pick out. i.e. ten random people. This quick tip is showing you one way how to pick random customers in Oracle using SQL. Read More »
Doing a TRUNC on a date might seem as a perfect solution if you want to query records having a column with both a date and a time. But, as you will see in this little Quick Tip, it is not always that smart. Read More »
If you have worked with SQL and PL/SQL for a while, you have probably been in a situation where you have a string that is delimited with a character, and you want the chunks of the string by themselves… In this tutorial we are going to look at a few ways to do this. Read More »
OracleTuts Oracle Training, Tutorials, and Videos from Beginner to Advanced
