Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
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...
Oracle SYSTIMESTAMP Function with Examples

Oracle SYSTIMESTAMP Function with Examples

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...
5 Tips to Improve Focus at Work by Removing Distractions

5 Tips to Improve Focus at Work by Removing Distractions

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

Oracle SQLERRM Function with Examples

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...
8 Things I Learnt Creating A Web App

8 Things I Learnt Creating A Web App

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

Oracle LOG Function with Examples

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