Complete IT Professional

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

Oracle LAG Function with Examples

In this article, I’ll explain what the Oracle LAG function does and how you can use it in your queries. Purpose of the Oracle LAG Function The Oracle LAG function allows you to get a value of a row different to the row that is being queried. You don’t need...
What My Average Day Looks Like

What My Average Day Looks Like

I thought I’d write an article to describe what my average work day looks like, so you can get a better understanding of what my full-time role involves. My Average Day I’m going to describe what my average day looks like. This could be any day of the...
Oracle SQLCODE Function Explained with Examples

Oracle SQLCODE Function Explained with Examples

The Oracle SQLCODE function is useful when working with exceptions. Learn what it is and see some examples in this article. Purpose of the Oracle SQLCODE Function The SQLCODE function returns the number code of the most recent exception. This number code is an...
Second Normal Form (2NF) Explained with Examples

Second Normal Form (2NF) Explained with Examples

As part of my normalisation series, this article explains how to transform a database into second normal form (2NF). Learn how to use second normal form in this article. What Is Second Normal Form? Second normal form is the second step in the process of normalisation....
Oracle LAST_DAY Function Explained with Examples

Oracle LAST_DAY Function Explained with Examples

The Oracle LAST_DAY function is a useful function to use with dates. Learn what it is and see some examples in this article. Purpose of the Oracle LAST_DAY Function The LAST_DAY function returns a date value equal to the last day of a specified date value. It’s...
189 Career Quotes To Motivate and Inspire You

189 Career Quotes To Motivate and Inspire You

I love a good quote. Quotes can motivate you, inspire you, and give you a new perspective on things. I’ve made a massive list here of career quotes, which are quotes about career, jobs, and success in general. Whether you’re looking for inspirational...
Oracle LEAD Function Explained with Examples

Oracle LEAD Function Explained with Examples

In this article, I’ll explain what the Oracle LEAD function is and how it works with some examples. Purpose of the Oracle LEAD Function The LEAD function returns values that are calculated from another row in your result set to the current row. You don’t...
Top 10 Posts on CITP For 2015

Top 10 Posts on CITP For 2015

I’ve written a lot of articles this year. In this article, I’ll highlight the most popular articles on Complete IT Professional in 2015. These articles are the ten most popular articles this year. The criteria I used is similar to the article I wrote last...
Oracle SUM Function Explained with Examples

Oracle SUM Function Explained with Examples

In this article, I’m going to explain the Oracle SUM function, how it can be used, and show some examples. Purpose of the Oracle SUM Function The Oracle SUM function sums or adds up the values specified in the expression. Like several other Oracle functions, you...
What is Oracle SOA?

What is Oracle SOA?

Working in technology for over fifteen years I have worked with a lot of different technologies. In my past, I created web services from scratch in Java. It is a time-consuming process and can be quite error prone getting all the files setup correct. In the last few...