Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
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...
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...