by Ben | Apr 18, 2016 | oracle

Have you ever needed to select the top N rows in your Oracle query? Or select from rows X to Y? In this article, I’ll show you how you can limit the number of rows in Oracle SQL. Selecting the Top Rows So, in this article, I’ll explain how to select the... by Ben | Apr 14, 2016 | oracle

This article will explain what the Oracle USER function does and how you can use it. Purpose of the Oracle USER Function The Oracle USER function provides you with the user ID of the current Oracle session. It’s a simple function that takes no parameters. ... by Ben | Apr 14, 2016 | oracle

This article explains how to use the Oracle ABS function and shows you some examples. Purpose of the Oracle ABS Function The Oracle ABS function returns the absolute value of a number. The absolute value of a number is a number without any negative signs attached to... by Ben | Apr 7, 2016 | oracle

The DENSE_RANK function is not a very well-known function, but it is pretty powerful. Learn how to use it and see some examples in this article. Purpose of the Oracle DENSE_RANK Function The purpose of the DENSE_RANK function is to calculate a rank of a row in a group... by Ben | Apr 4, 2016 | oracle

A common question in Oracle SQL, and SQL in general, is to select rows that match a maximum value for a column. Let’s see how you can do that in SQL. The Problem Let’s say you have a set of data that has some values in it. These examples use a student... by Ben | Mar 31, 2016 | oracle

In this article, I explain what the SYSTIMESTAMP function is and show some examples. Purpose of the Oracle SYSTIMESTAMP Function The SYSTIMESTAMP function is used in Oracle to return the system date of the system that stores the database, including fractional seconds... by Ben | Mar 28, 2016 | tips

Do you often find yourself not focusing at work? Or, you try to focus, but something else comes along and distracts you? I know how this feels. I’ve listed five ways to remove distractions and increase focus in this article. I’ve been able to improve my... by Ben | Mar 24, 2016 | oracle

The Oracle SQLERRM function is useful when working with exceptions. Learn what it is and how to use it in this article. Purpose of the Oracle SQLERRM Function The SQLERRM function returns the error message that relates to the error number provided. This function is... by Ben | Mar 21, 2016 | web-app-case-study

In mid 2014 I announced I was creating a web app for a friend of mine, and I was documenting the process on this site. This article mentions a few things I learnt during this process. If you’re looking to create some kind of application or a project on the side,... by Ben | Mar 17, 2016 | oracle

The Oracle LOG function is used to return a logarithm of an expression. Learn how to use it and see some examples in this article. Purpose of the Oracle LOG Function This function returns the logarithm of the parameters you provide it. Note: This function does not...