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 »
Many times in my career, working with Oracle, I have had to search through lots of code to figure out what actually fills data into i.e. the the table I am pulling data from in my report. To do this I have been using the two Oracle Data Dictionary views USER_SOURCE, and ALL_SOURCE. I use these (as well as others) ... Read More »
A while ago I wrote several similar articles on how to use the different Analytic functions in Oracle. I have now chosen to merge these articles into one useful article/document that you can print out or save to your computer for your own reference. In this tutorial I will try to explain to you how to use them, through practical ... Read More »
Working with dates is fun. In this post we are going to show a method to easily find the first and last date of the current month, previous month, and next month. Knowledge about this will come in handy if you i.e. want to do a year-over-year sales analysis, or maybe you would like to take the current month’s sales ... Read More »
OracleTuts Oracle Training, Tutorials, and Videos from Beginner to Advanced
