Complete IT Professional

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

Oracle SOUNDEX Function with Examples

The Oracle SOUNDEX function is one of the most interesting functions I’ve used in Oracle. Learn what it is and how it works in this article. Purpose of the Oracle SOUNDEX Function The Oracle SOUNDEX function allows you to check what a value sounds like. It...
The Importance of Routine

The Importance of Routine

In the last two weeks, I’ve learnt about the importance of a routine. How does it relate to your career, and why should you care? The Last Two Weeks So, you might have noticed there hasn’t been a post on Complete IT Professional in the last week or so. I...
Oracle CURRENT_DATE Function with Examples

Oracle CURRENT_DATE Function with Examples

The Oracle CURRENT_DATE function is another Oracle function for returning a date from the system. Find out what it does and how it’s different from the other functions in this article. Purpose of the Oracle CURRENT_DATE Function The CURRENT_DATE function is used...
Oracle USERENV Function with Examples

Oracle USERENV Function with Examples

The Oracle USERENV function allows you to get information about the current session. Learn how to use the USERENV function in this article. Purpose of the Oracle USERENV Function The purpose of the USERENV function is to get information about your current session....
What Are Oracle SQL Analytic Functions?

What Are Oracle SQL Analytic Functions?

In this article, I explain what Oracle SQL analytic functions are, how they are different from other functions, and show you some examples. What Are Oracle SQL Analytic Functions? Analytic functions are functions that calculate an aggregate value based on a group of...
Oracle NEXT_DAY Function with Examples

Oracle NEXT_DAY Function with Examples

The NEXT_DAY function is a handy date manipulation function provided by Oracle. In this article, I’ll explain how to use it and show you some examples. Purpose of the Oracle NEXT_DAY Function The Oracle NEXT_DAY function returns the date of the first weekday...
What Are Oracle SQL Aggregate Functions?

What Are Oracle SQL Aggregate Functions?

Oracle SQL aggregate functions are very useful, and are some of the most commonly used functions. Learn what Oracle SQL aggregate functions are and what they do in this article. What Are Oracle SQL Aggregate Functions? Aggregate functions are functions that allow you...
Oracle CURRENT_TIMESTAMP Function with Examples

Oracle CURRENT_TIMESTAMP Function with Examples

The CURRENT_TIMESTAMP function is one of the many time and date-related functions in Oracle. Learn how to use it and see some examples in this article. Purpose of the Oracle CURRENT_TIMESTAMP Function The Oracle CURRENT_TIMESTAMP function will display the current date...
Oracle CREATE TABLE Syntax and Examples – The Complete Guide

Oracle CREATE TABLE Syntax and Examples – The Complete Guide

Creating database tables in Oracle is one of the most common tasks an Oracle developer or Oracle DBA does. Learn how to create tables, what the syntax is, and see some examples in this article. What Is The Create Table Command Used For? The CREATE TABLE command is...
Oracle BITAND Function with Examples

Oracle BITAND Function with Examples

In this article, I’ll explain how to use the Oracle BITAND function and show you some examples. Purpose of the Oracle BITAND Function The Oracle BITAND function is used to perform what’s called a standard bitwise AND operation. It’s used to compare...