by Ben | May 5, 2016 | oracle

In this article, I’ll show you what the ASCII function is and demonstrate some examples. Purpose of the Oracle ASCII Function The ASCII function is used to convert a single character into a number that represents the character. It’s how you get an ASCII... by Ben | May 3, 2016 | oracle

As someone who works with and blogs about Oracle, I like to read other Oracle blogs. I also noticed it was hard to find a good list of the top Oracle SQL blogs. So, I decided to make my own list. Top Oracle SQL Blogs I had found more than 50 Oracle SQL blogs, but... by Ben | Apr 28, 2016 | oracle

In this article, I explain what the Oracle SIGN function is and show you some examples. Purpose of the Oracle SIGN Function The Oracle SIGN function is used to find the sign of a number. The “sign” indicates whether the number is positive, negative, or... by Ben | Apr 26, 2016 | oracle

Have you heard of the term “materialized view” before? How is it different from a view? In this article, I’ll explain what the difference is between a view and a materialized view in Oracle. What is a View? A view is a database object that is created... by Ben | Apr 21, 2016 | oracle

The MIN function is one that I use quite a lot in Oracle SQL. In this article, I’ll explain how to use it, and show you some examples. Purpose of the Oracle MIN Function The MIN function returns the minimum value of the expression you provide it. This is almost... 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...