Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
Oracle ASCII Function with Examples

Oracle ASCII Function with Examples

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...
Top 50 Oracle SQL Blogs for 2016

Top 50 Oracle SQL Blogs for 2016

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...
Oracle SIGN Function with Examples

Oracle SIGN Function with Examples

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...
Oracle MIN Function with Examples

Oracle MIN Function with Examples

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...
How to Limit the Number of Rows in Oracle SQL After Ordering

How to Limit the Number of Rows in Oracle SQL After Ordering

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...
Oracle USER Function with Examples

Oracle USER Function with Examples

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.  ...
Oracle ABS Function with Examples

Oracle ABS Function with Examples

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...
Oracle DENSE_RANK Function with Examples

Oracle DENSE_RANK Function with Examples

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...
How to Select Rows with Max Value for a Column in Oracle SQL

How to Select Rows with Max Value for a Column in Oracle SQL

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...