Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
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...
12 Game of Thrones Career Lessons You Can Benefit From

12 Game of Thrones Career Lessons You Can Benefit From

The popular fantasy show has many characters and plot lines. We can learn a lot from them on how we can improve our career. Game of Thrones is probably the best show I’ve ever seen. Every week, my girlfriend and I watch it, glued to the screen for an hour and...
Oracle AVG Function with Examples

Oracle AVG Function with Examples

The Oracle AVG function is a common function in Oracle SQL. I’ll explain how to use it in this article and show you some examples. Purpose of the Oracle AVG Function The AVG function calculates the average of a series of values that you provide to it. Most of...